Is there a way to get excel to output the numerical value of todays 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 todays date divided by the number of days in the month.
Right now, I manually update a cell to todays day every time I open the
spreadsheet but I want excel to update automatically.

Thanks!