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.'
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 %

Possible answer

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:
Read more
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 ...
Read more
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 ...
Read more
Positive: 53 %
... you how to calculate the number of months ... the number of months between two dates in Excel ... month is returned even though only two days ...
Read more
Positive: 30 %

Show more results