IF formula with date range that defines a set time period
Statement to solve for -
If FINISH date is between x and y dates, the it = 30-60 (time period in a drop down)
Formula created, but not working
=IF(Finish)42 >=DATE(2020, 12, 21) OR <=DATE(2020, 12, 25), "30-60")
Can anyone help solve for this so that I can automated setting a time period based on the task date?
Help Article Resources
Check out the Formula Handbook template!