| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Current Run Rate
I am trying to calculate the current sales rate. If I have $5000 in sales
after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Current Run Rate
If you have a version of Excel 2007 and have the Analysis Toolpack installed
or have Excel 2007, to determine the number of days in the current month you can use: =EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0) So if your $5000 is in A1 and your 3 is in A2 in A3 put: =A1/A2*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)) to calculate $48333.33 for February. Tyro "Coley" wrote in message ... I am trying to calculate the current sales rate. If I have $5000 in sales after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Current Run Rate
Correction. If you have a version of Excel 2007 should read: If you have a
version of Excel prior to Excel 2007 .......... Tyro "Tyro" wrote in message t... If you have a version of Excel 2007 and have the Analysis Toolpack installed or have Excel 2007, to determine the number of days in the current month you can use: =EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0) So if your $5000 is in A1 and your 3 is in A2 in A3 put: =A1/A2*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)) to calculate $48333.33 for February. Tyro "Coley" wrote in message ... I am trying to calculate the current sales rate. If I have $5000 in sales after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Current Run Rate
Outstanding! Works great.
"Tyro" wrote: Correction. If you have a version of Excel 2007 should read: If you have a version of Excel prior to Excel 2007 .......... Tyro "Tyro" wrote in message t... If you have a version of Excel 2007 and have the Analysis Toolpack installed or have Excel 2007, to determine the number of days in the current month you can use: =EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0) So if your $5000 is in A1 and your 3 is in A2 in A3 put: =A1/A2*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)) to calculate $48333.33 for February. Tyro "Coley" wrote in message ... I am trying to calculate the current sales rate. If I have $5000 in sales after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Current Run Rate
You're welcome.
Tyro "Coley" wrote in message ... Outstanding! Works great. "Tyro" wrote: Correction. If you have a version of Excel 2007 should read: If you have a version of Excel prior to Excel 2007 .......... Tyro "Tyro" wrote in message t... If you have a version of Excel 2007 and have the Analysis Toolpack installed or have Excel 2007, to determine the number of days in the current month you can use: =EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0) So if your $5000 is in A1 and your 3 is in A2 in A3 put: =A1/A2*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)) to calculate $48333.33 for February. Tyro "Coley" wrote in message ... I am trying to calculate the current sales rate. If I have $5000 in sales after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Current Run Rate
Another formula to determine the number of days in the current month is:
=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)) So with $5000 in A1 and 3 in A2, put =A1/A2*DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)) will calculate 48333.33 Tyro "Coley" wrote in message ... I am trying to calculate the current sales rate. If I have $5000 in sales after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Current Run Rate
to determine the number of days in the current month you can use:
=EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0) Try this: =DAY(EOMONTH(NOW(),0)) =A1/A2*DAY(EOMONTH(NOW(),0)) -- Biff Microsoft Excel MVP "Tyro" wrote in message t... If you have a version of Excel 2007 and have the Analysis Toolpack installed or have Excel 2007, to determine the number of days in the current month you can use: =EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0) So if your $5000 is in A1 and your 3 is in A2 in A3 put: =A1/A2*(EOMONTH(TODAY(),0)-EOMONTH(EDATE(TODAY(),-1),0)) to calculate $48333.33 for February. Tyro "Coley" wrote in message ... I am trying to calculate the current sales rate. If I have $5000 in sales after 3 days ($1666.67/day) I want to show $48333.33 for the current monthly rate (Feb 29th). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
| Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Linear Mode
