Calculating how many days past in a month from today

A

Arup C

Hi everybody,
Is there any way to calculate days past in a month from the date calculated
by today function?
 
D

Django Cat

Frederik said:
Perhaps with

=DAY(TODAY())

greetings
Click to expand...

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

--
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<Django Cat> wrote in message | 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
|
| --
|
 
Top