=DAY(TODAY())
"Jake" wrote in message
...
Is there a way to get excel to output the numerical value of today's day
of
the month? For example, today is 12/17/04. I want the value in the cell
to
be "17" today. When I open the file tomorrow, I want it to automatically
change to "18". I have figured out how to get excel to DISPLAY these
numbers
(=today(), then change formatting to custom date, dd). However, the true
value of the cell is still the date code (in this example, 38338). So if
I
multiply that cell by 1, the result is 38338, not 17. I want 17. Can
this
be done?
To give a bit more detail on why I want to do this - I want to be able to
calculate the percentage of this month that is complete. So I want to
have a
ratio that equals today's date divided by the number of days in the month.
Right now, I manually update a cell to today's day every time I open the
spreadsheet but I want excel to update automatically.
Thanks!
|