| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula using a date range
I currently have this formula in a spreadsheet:
=SUMPRODUCT(--(YEAR(Roster!$E$2:$E$646)=2007), --(Roster!$C$2:$C$646=B8), --(Roster!$H$2:$H$646="Non-Exp")) Essentially it counts data based on three criteria, the first being if the data includes a date in 2007. My company changed from a fiscal year to a calendar year. Is there a way I can modify the above formula to go from counting if a date included "2007" to counting if a date included July 1, 2007 - June 30, 2008???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| IF Date range formula | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| how do i use the sum if formula with a date range? | Excel Worksheet Functions | |||
Threaded Mode
