Formula to determine is something is due this week

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi all -

I would like to calculate if something is due this week based on a target date in another cell. 

I have tried this formula:  =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes")

This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for. 

Is it possible to determine if something is due just in the current week?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!