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
|