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

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

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.'
Positive: 72 %
Answer #2 | 20/12 2013 03:15
i tell u exel fomula. =datedif(date-25-09-2013,date-26-08-2014,"ym:) + enter key.
Positive: 66 %

How to convert date to weekday name or month name in Excel? ... Free to try with no limitation in 30 days. Read More Free Download Now. Related articles:
Positive: 72 %
You can find the first date of any month in three ... Find first and last date of any month using Excel formula. ... Are you sure you want to ...
Positive: 67 %
How to Calculate the Number of Months Between 2 Dates in Excel ... want to know the differences in days, ... Days in Each Month Using Excel ...