Solved Help writing an IF statement using date ranges

October 19, 2015 at 15:03:20
Specs: Windows 7
Formula is in Cell A10
Formula needs to look at Cell W10 and if the date in W10 is between 2/12/16 and 3/20/16 then it returns "528/522", but if the value of W10 is between 3/21/16 and 6/18/16, then it returns "567/565", etc. I can't figure out the syntax

See More: Help writing an IF statement using date ranges

Report •


#1
October 19, 2015 at 16:15:54
✔ Best Answer
Try this and see how it works:

=IF(AND(W10>=DATE(2016,2,12),W10<=DATE(2016,3,20)),"528/522",IF(AND(W10>=DATE(2016,3,21),W10<=DATE(2016,6,18)),"567/565",))

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question