Calculating how many days past in a month from today

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everybody,
Is there any way to calculate days past in a month from the date calculated
by today function?
 
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

--
 
=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
|
| --
|
 
Back
Top