Another one.

If you're using a version of Excel prior to Excel 2007 this needs the
Analysis ToolPak add-in installed.

=EOMONTH(A1,0)-A1

Format as General or Number

--
Biff
Microsoft Excel MVP


"Ricky" wrote in message
...
Can anyone suggest how I can have the number of days remaining in the
month, from a date entered in A1, displayed as a numeric, ie:

Cell A1 has "20/01/09"

I would like a formula to return the number of days remaining in the
month, in this case "11" days (31 less 20).

Thanks - Ricky