Calculating how many days past in a month from today

[Guest]

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

 

[Frederik]

Perhaps with

=DAY(TODAY())

greetings

 

[Django Cat]

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

--

 

[Roger Govier]

Hi

For days past (therefore not including today, use
=DAY(TODAY())-1

 

[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
|
| --
|

 

[Django Cat]

Niek Otten said:

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

Thanks, that works!
DC

--