No. of days between two dates (2000/any)

Topic

New Reply

Hope someone out there can help me puh-lese…what I’m trying to do is put in a formula that calculates the number of months (rounded to two decimal places) between the last day of the current month (I will type in 08/01 – mm/yy format – in a particular cell) and another date in another cell. So I really need to know the month equiv of the days360 formula, and also how to get it to automatically calculate the date of the last day in the current month and use that in the calculation. Hopefully the attached makes sense of my scrawl. Any help gratefully accepted!!

Reply | Quote

Replies

You can get the last day of a month with the date function, by using a zero as the argument for the day. e.g. this gives 30 november:
=DATE(2001,12,0)

Reply | Quote

The last date of the month could be calculated with an Excel function: EOMONTH(date;0)

Reply | Quote

If the start date is in A1, and the end date is in B1 see if this will give you what you want:

=DATEDIF(DATE(YEAR(A1),MONTH(A1)+1,0),B1,"m")+DAY(B1)/DAY(DATE(YEAR(B1),MONTH(B1)+1,0))

Reply | Quote