On Fri, 17 Dec 2004 13:03:06 -0800, "Jake"
wrote:

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?

=DAY(TODAY())


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.


=DAY(TODAY())/DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))

=17/31

=0.548387097




--ron