Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get an IF statement to pull a date range??
I've created an IF statement with multiple formulas, but I can't seem to
figure out if it is possible to pull the information by a specific date range. I have sales reps that visit customers on specific dates and I need my tally sheet to only pull dates within that current week. Does anyone know if this is possible?? This is what I have so far: =SUM(IF(sales rep!AB2:AB216=I3,IF(sales rep!$AA$2:$AA$216=I4,IF(sales rep!P2:P216=I7,IF(sales rep!$N$2:$N$216=DATEVALUE("3/18/2005"),1,0))))) If you look above I have it to calculate the date value starting at 03-18-05, but I would like it to only pull that date through the next week. Help??? :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date in an IF statement | Excel Worksheet Functions | |||
Completion Percentage of a date range | Excel Discussion (Misc queries) | |||
How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
How can I sum information in a list with a date range? | Excel Worksheet Functions |