IF formula combined with dates

Silvia C Rodriguez
Silvia C Rodriguez โœญโœญโœญโœญ
edited 12/09/19 in Formulas and Functions

Hello,

I need help. I am wondering how can I create a formula using the IF function with a range of dates. For example:

If the date is between 01/01/2018 and 03/30/2018, then write 1st Quarter., and if the date is between 04/01/2018 and 06/30/2018, then 2nd. Quarter, etc....

ย 

Thank you in advance!

ย 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!