Why does this formula not work today?

L_123
L_123 ✭✭✭✭✭✭
edited 06/01/20 in Formulas and Functions

=DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()) - WEEKDAY(TODAY()))


It is the Weekday part of the formula that is stopping it from running. Using INT and VALUE and whatever else I can think of doesn't work.


@Genevieve P

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!