Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
Hi All
I have an IF statement for a list of dates. I want to a criteria that is between 2 dates If A1 is between 12.3.06 and the 15.3.06 I have tried various combinations and checked the help but the only one I cant find is between Can anyone help (it is Excel 2002) any suggestions greatly appreciated Rexmann |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
Hi
=AND(A1=DATE(2006,3,12),A1<=DATE(2006,3,15)) -- Regards Roger Govier "rexmann" wrote in message ... Hi All I have an IF statement for a list of dates. I want to a criteria that is between 2 dates If A1 is between 12.3.06 and the 15.3.06 I have tried various combinations and checked the help but the only one I cant find is between Can anyone help (it is Excel 2002) any suggestions greatly appreciated Rexmann |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement
Hi Roger
Nice one - thank you for your help, much appreciated Cheers Rexmann "Roger Govier" wrote: Hi =AND(A1=DATE(2006,3,12),A1<=DATE(2006,3,15)) -- Regards Roger Govier "rexmann" wrote in message ... Hi All I have an IF statement for a list of dates. I want to a criteria that is between 2 dates If A1 is between 12.3.06 and the 15.3.06 I have tried various combinations and checked the help but the only one I cant find is between Can anyone help (it is Excel 2002) any suggestions greatly appreciated Rexmann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |