Date range formula

Options
mmscott92
mmscott92 ✭✭
edited 12/09/19 in Smartsheet Basics

Having an issue with date range formula.

I am trying to accomplish returning values such as Q2 FY18. Q3 FY18, Q4 FY18 based on the date showing in the "Finish" column.  However, I am challenged with the proper format to enter the date range, and then multiple at that.

I initially used ...

=IF([Finish]2>=10/29/2017, [Finish]2<=1/27/2018), "Q2 FY18", "x")

but have tried multiple other formulas with no success.  What is the correct format of formula for this?

Screen Shot 2018-02-13 at 6.47.03 PM.png

Comments