ExcelBanter - If statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If statement (https://www.excelbanter.com/excel-discussion-misc-queries/122475-if-statement.html)

rexmann

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

Roger Govier

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

rexmann

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

All times are GMT +1. The time now is 01:51 AM.