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?


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: 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

Get the day of month from date in Excel (DAY function) ... you may want to know which dates are working days and which are weekends.
Read more
Positive: 72 %
Adding Months to a Date in Excel ... if it calculates the last day of the month. ... a report and i needed to know how to add 6 months to the ...
Read more
Positive: 67 %
... but what you really want to see is what day of week those dates ... You'll just have to know the appropriate excel shortcut: =TEXT ... Month: mmm will ...
Read more
Positive: 53 %
Change date value to first day of the month of ... doesn't want the day to ... these two function because they are now part of Excel ...
Read more
Positive: 30 %

Show more results