FIND THE ANSWERS

I want to know the month and days in that month in Excel?

Answer this question

  • I want to know the month and days in that month in Excel?


Answers

Answer #1 | 20/12 2013 02:49
you can just use a normal calculation so if CELL1 in spreadsheet is A1=25/9/13 and CELL 2 with your second date is B1=26/8/14 CELL3 (C1) =B1-A1 (number of days between the dates) For some reason it won't let me add the full formula, you can find it on this page:http://office.microsoft.com/en-gb/excel-help/calculate-the-difference-between-two-dates-HP010070467.aspx "CELL 4 (D1) = (YEAR(C1)-YEAR(B1))*12+Month(C1)-Month(B1) will calculate the months between 2 dates in 2 different years" you can also format the dates as numbers then convert back if it's easier for you that way.'
Answer #2 | 20/12 2013 03:15
i tell u exel fomula. =datedif(date-25-09-2013,date-26-08-2014,"ym:) + enter key.

Possible answer