| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula for # of sales days in a month?
I'm looking for a formula that will calculate number of sales day in a month
according to the following paramaters. For example, column A has number of sales days as 1,2,3, etc., column B has either a number or a zero in it, column C has either a number or a zero in it. I need the formula to look at the values in B &C to determine what sales day it is. For example, of B10 and C10 are zero, then I need the formula to look at B9 and C9. If B9 and C9 are zero, then I need the formula to look at B8 and C8. If there is any value other than zero in B8 and C8, then I need the formula to return the value listed (1,2,3, etc.) from column A. Anyone know how to do this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula converts date to month only | Excel Discussion (Misc queries) | |||
| Generating business days in a calendar month, EXCLUDING holidays | Excel Worksheet Functions | |||
| number of days in a month | Excel Worksheet Functions | |||
| Days of sales in inventory template | Setting up and Configuration of Excel | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Threaded Mode
