Weekday Formula Error?

Options
Chris Mondeau
Chris Mondeau ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello all!

I've been trying to create a time entry sheet like many others, but am running into an error with the Weekday() formula.

I'm using the formula on a system column for the date/time the row was created. I have an entry for 01/22/18 4:20 PM, which returns "2" for the weekday value. Right after I have an entry for 01/22/18 7:23 PM, which returns "3". It caught me off guard since it's still the same day. The only thing I can think of is the system's date/time set-up is GMT or something that has the hours set for different date thresholds.

Link to Example Sheet

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!