I need to calculate the # of days between a date and the end of that month. Any ideas?

**dougdrex** · 05-03-2013, 12:08 PM

The formula needs to work for any of the months. I need it for the purpose of calculating daily interest.

Any ideas are greatly appreciated!

**popipipo** · 05-03-2013, 12:12 PM

=date(year(a1),month(a1)+1,0)-a1

Try this one

**Kevin UK** · 05-03-2013, 12:14 PM

Hi dougdrex

Try the following and format B1 as general.
A1 = date
In B1: =EOMONTH(A1,0)-A1

**Justair07** · 05-03-2013, 12:20 PM

never mind my answer was the same as the second post

**dougdrex** · 05-03-2013, 12:45 PM

Both of those work great. Thanks to both of you!

Re: I need to calculate the # of days between a date and the end of that month. Any ideas