Formula help

[markster]

Afternoon everyone

I need to do an IF formula that says that if the date in C2 is not BETWEEN 1-AUG-17 and 31-JUL-18 (inclusive than leave C2 Blank). Can anyone help. Thanks

 

[Joe4]

Use an OR statement with your IF, i.e.

=IF(OR(C2 < DATE<date(2017,8,1),c2>(2017,8,1),C2 > DATE(2018,7,31)),...)

</date(2017,8,1),c2>

 

[markster]

Use an OR statement with your IF, i.e.

=IF(OR(C2 < DATE<date(2017,8,1),c2>(2017,8,1),C2 > DATE(2018,7,31)),...)

</date(2017,8,1),c2>

Ok that's perfect thanks - much appreciated.

Mark

 

[Joe4]

You are welcome.

 

[jtakw]

Hi,

Another way to write it...

=IF(AND(C2>=DATE(2017,8,1),C2<=DATE(2018,7,31)),"value if true","")

Change "value if true" to what you want when C2 IS between 8/1/2017 and 7/31/2018, otherwise, results Blank.

 

[markster]

Hi,

Another way to write it...

=IF(AND(C2>=DATE(2017,8,1),C2<=DATE(2018,7,31)),"value if true","")

Change "value if true" to what you want when C2 IS between 8/1/2017 and 7/31/2018, otherwise, results Blank.

Thanks both -much appreciated.

 

[jtakw]

You're welcome.