Formula to count back 30 working days
Comments
-
That formula should work. I just tested it myself. Is the column you are putting the formula in formatted as a Date Column?
-
That's it! It was a text column - thank you so much!
-
It does work now but it's counting back calendar days and not work days - any ideas??
-
Hmm... I'm not sure. I just tested it again, and it was counting "workdays" (Monday - Friday). Putting in a start date of 6/29 gives me a result of 5/18.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!