Date Range Formula


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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!