| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what is syntax for if(between range of dates,"Q1","Q2")?
HI,
I'm trying to create the following formula: if cell b34 is between Nov 1/04 and Jan 31/05, enter "Q1" if cell b34 is between Feb 1/05 and April 30/05, enter "Q2" etc. What is the correct syntax for this formula? I have entered: if(11/01/04<=b34<=01/31/05,"Q1",if(02/01/05<=b34<=04/30/05,"Q2",if(etc etc))) But this isn't working. Does anyone know how to create an If statement based on a cell falling within a range of dates? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| syntax to refer to a range as an array? | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
