| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate sales run rate
Hello All! I am in need of help to calculate two sales run rates using
formulas. The formula I currently use for a monthly run rate is: =SUM(MTD Sales/Today's day # in month * Total # Days in month) I manually add up number of weekdays in month (minus holidays) & today's day # in month. Through browsing the board, I am using the following formula to figure number of weekdays in date range minus holidays (K1:K40) =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(J2&":"&J3)),2)<6))- COUNT(K1:K40) (1) How do I calculate monthly run rate based on today's date? (2) How do I calculate quarterly run rate based on today's date? TIA for any suggestions :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
| calculate predicted sales value | Excel Worksheet Functions | |||
| projected sales forecast broken down into an hourly rate not linea | Excel Discussion (Misc queries) | |||
| how do I create a formula to calculate sales tax using Yes & No | Excel Worksheet Functions | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
Threaded Mode
