Simple (I hope) date formula needed

[derekpegg]

I need a formula to calculate the number of days between NOW() and the first day of the next month, ie, 01/12/05 = 1 day, today. Is there a way to have excel do this as months vary in length. Thanks in advance.

 

[fairwinds]

Hi,

Try:
=EOMONTH(TODAY(),0)-TODAY()+1

 

[derekpegg]

Thanks for the speedy reply, but that formula returns a #NAME?. I think this requires an add-in. The problem is that other users will be using this workbook who do not have the add-in, as I guess it is machine specific and not packaged into the worksheet?

 

[fairwinds]

EOMONTH belongs to analysis tool pack. It is included in the normal Excel instalation but you need to enable it (Tools - add-ins...)


Alternatively:

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-TODAY()

does not requre analysis tool pack.

 

[derekpegg]

OK. thanks, but that returns "01/01/00"?

 

[fairwinds]

That is correct, it is November 30 today.

Just format cell as general.

 

[derekpegg]

Oh yes. Great. Thanks for your help. Appreciate it.