=EOMONTH(TODAY(),0)-TODAY()

Substitue a cell reference instead of 1 / both of the TODAY's if needed.

"Keith" wrote:

Hello,

I am running Excel 2000 and I have a question regarding the Date() function.
I am trying to create a template that in one cell (A1) I put in the month
(ex. April) and then in cell (B3) it would have a date function that finds
todays date and subtracts todays date from the number of total days in the
month to give me the total remaining days for the month. I have tried untill
I'm blue in the face and I can not get this to work.

Thank you in advance,

Keith