| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement
Thank you David! That worked!
Liz "David Biddulph" wrote: =IF(AND($D2<=F$1+6,$E2=F$1),1,"") -- David Biddulph Liz C wrote: I don't see in your formula how it takes the date in F1 into account. I have week starting dates across the top and employees with scheduled work start and end dates down the side. I want to put a "1" in the cells for the weeks they work. Like below: start end 1/5/09 1/12/09 1/19/09 fred smith 12/18/08 2/13/09 1 1 1 I really appreciate your help. Liz "Liz C" wrote: I have week beginning dates in row 1 starting on F, Work Start dates in column D, and Work End dates in column E. How can I get it in cell F2 to put a "1" if the work start and end dates fall within the week in F? Thanks again for your help! Liz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
