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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<Django Cat wrote in message o.uk...
| Frederik said:
|
| Perhaps with
|
| =DAY(TODAY())
|
| greetings
|
|
| That's useful to know. If I wanted to know the number of days remaining in the month (bearing in mind months can be 30, 31, 28
or even 29 days long), how could we do that?
| DC
|
| --
|