Date Range Formula

Ann Foley

Hi!

I'm trying to say: If a date in one cell is between April 1, 2020 and June 30, 2020, then return "Q2" in this new cell and if there is no date listed, return nothing in this new cell.

What is wrong with my formula?

=IF([Date Visited]@row, <=DATE(2020, 4, 1) >= DATE(2020, 6, 30), ="Q2", 0)

Paul Newcome

I just took another look at the formula. I had adjusted the syntax without actually looking at what it was saying. Try switching your greater than and less than signs around.

Paul Newcome

You will want to use an AND statement to combine the two sets of criteria.

=IF(AND([Date Visited]@row <=DATE(2020, 4, 1), [Date Visited]@row >= DATE(2020, 6, 30)), "Q2", 0)

Ann Foley

Thank you! Now I'm not getting a formula error but when I type in a date 4/2/20 for example, my cell says 0 instead of Q2.

Paul Newcome

Is it set to a date type column?

Ann Foley

My date visited column is set up as a date column. The column where I'm adding the formula (my Quarter completed column) is set as text/number

Paul Newcome

I just took another look at the formula. I had adjusted the syntax without actually looking at what it was saying. Try switching your greater than and less than signs around.

Ann Foley

Oh duh. Thank you as always!!

Paul Newcome

Happy to help! 👍️