WEEKDAY formula is giving me the wrong result

Tamara K

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?

Andrée Starå

Hi Tamara,

I tried it and it's giving me a 1 for Sunday. Which time zone are you in and what is it in the Account (Circle/Profile Picture in the upper right corner) > Personal Settings > Settings?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

In addition to the timezone issue, you could also try a DATEONLY function to pull only the date from the Date/Time column for your WEEKDAY function.

 

=WEEKDAY(DATEONLY([Date/Time]@row))