How does "in the next x days" calculate days?

JuliaE ✭✭✭
edited 06/27/22 in Formulas and Functions

I am working on a schedule for multiple employees and I would like for the different dates to be highlighted. How does the "in the next xx days" function work? My conditional formating is recognizing today (6/27) & 6/28 as both being in the next 1 days. Thanks for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!