WEEKDAY formula is giving me the wrong result

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?

Find more posts tagged with

Formulas

Comments

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))

Sign in to join the conversation!

Quick Links

Trending discussions

Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…