| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what is syntax for if(between range of dates,"Q1","Q2")?
Hi
=IF(AND(B34=DATE(2004,11,1),B34<=DATE(2005,1,31)) ,"Q1",IF(AND(B34=DATE(2005,2,1),B34<=DATE(2005,4, 30)),"Q2","")) Regards Roger Govier TLB wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what is syntax for if(between range of dates,"Q1","Q2")?
Perfect, thank you.
"Roger Govier" wrote: Hi =IF(AND(B34=DATE(2004,11,1),B34<=DATE(2005,1,31)) ,"Q1",IF(AND(B34=DATE(2005,2,1),B34<=DATE(2005,4, 30)),"Q2","")) Regards Roger Govier TLB wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what is syntax for if(between range of dates,"Q1","Q2")?
You are very welcome. Thanks for the feedback.
Also apologies to everyone, I just noticed my system date had gone haywire and was reading the 6th. I have now come back to the present!! Regards Roger Govier TLB wrote: Perfect, thank you. "Roger Govier" wrote: Hi =IF(AND(B34=DATE(2004,11,1),B34<=DATE(2005,1,31 )),"Q1",IF(AND(B34=DATE(2005,2,1),B34<=DATE(2005, 4,30)),"Q2","")) Regards Roger Govier TLB wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
