Forum Discussion
Solved
Help: IF Statement for Multiple Date Ranges
I have a column of dates (A) and a blank column (B) that I'm looking to populate with specific text based on the date in A. For example, if the date in A1 falls between (>=) 8/28/17 and (<) 8/27/18, ...
Excel treats 8/28/17 as a calculation: 8 divided by 28 divided by 17.
Replace 8/28/17 with DATE(2017,8,28) and similarly for the other dates in your formula.
Excel treats 8/28/17 as a calculation: 8 divided by 28 divided by 17.
Replace 8/28/17 with DATE(2017,8,28) and similarly for the other dates in your formula.
Thank you!!!