Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculate Monthly Time Pace
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculate Monthly Time Pace
"HeatherJ" wrote:
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% 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 ----- "HeatherJ" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculate Monthly Time Pace
Hi,
try =DAY(TODAY())/DAY(EOMONTH(TODAY(),1)) format cell as percentage "HeatherJ" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Monthly Inventory Usage | Excel Worksheet Functions | |||
Calculate monthly contributions | Excel Worksheet Functions | |||
How could I calculate the monthly payment of GPM. | Excel Discussion (Misc queries) | |||
How to calculate IRR from a monthly income stream | Excel Discussion (Misc queries) | |||
How do I calculate running pace? | Excel Worksheet Functions |