WEEKDAY formula is giving me the wrong result

Tamara K
Tamara K
edited 12/09/19 in Formulas and Functions

Ok, am I missing something obvious or is the formula not working properly? As shown in the image, the date is 6/2. Which is a Sunday. But when I use the "WEEKDAY" formula to reference the date column it keeps coming back with "2," indicating that it's Monday.

What am I doing wrong?

Day2.jpg

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!