Auto Calculate Monthly Time Pace

  • Thread starter Thread starter HeatherJ
  • Start date Start date
H

HeatherJ

I need to show how far into a month we are at any given time in % form. I
want this to change every day automatically. Example:

Today is day 27 of 31 days in January - 87%

if today was 2/17/10 it would need to show 17/28 or 61%, 12/20/10 would be
20/31 or 65%, and so on for each day throughout 2010 (12/20/10 would be 65%)

Is there a formula or function to do this?

Thanks!
Heather
 
HeatherJ said:
I need to show how far into a month we are at any given time in % form. [....]
Today is day 27 of 31 days in January - 87%
Click to expand...

One way:

=day(today()) / day(eomonth(today(),0))

formatted as Percentage. If you get a #NAME error, see the Help page for
EOMONTH.


----- original message -----
 
Back
Top