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

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

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

2. ## Re: No. of days between two dates (2000/any)

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)

3. ## Re: No. of days between two dates (2000/any)

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

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

4. ## Re: No. of days between two dates (2000/any)

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•