Try this:

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

if you don't want to include the date in A1 as being part of the
range. You can omit the -1 from the end if your dates are inclusive.

Hope this helps.

Pete


On Jan 26, 1:12*pm, Ricky wrote:
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