0 being added to my weekdays

Kelsey Ciarrocca

Hi all!

I'm trying to list the weekday (using WEEKDAY) based off my date field. It's so weird though, I'm getting a "0" added at the beginning of every day besides Monday and Sunday. Does anyone know how I can fix this?

I tried using "&" and "," instead of plus signs, but that didn't work.

=IF(WEEKDAY([Calendar Date]2) = 1, "Sunday") + IF(WEEKDAY([Calendar Date]2) = 2, "Monday") + IF(WEEKDAY([Calendar Date]2) = 3, "Tuesday") + IF(WEEKDAY([Calendar Date]2) = 4, "Wednesday") + IF(WEEKDAY([Calendar Date]2) = 5, "Thursday") + IF(WEEKDAY([Calendar Date]2) = 6, "Friday") + IF(WEEKDAY([Calendar Date]2) = 7, "Saturday")

Mark Cronk

Hi @Kelsey Ciarrocca ,

Try:

=IF(WEEKDAY([Calendar Date]@row = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))

Mark

Mark Cronk

Good evening @Kelsey Ciarrocca ,

It was missing a paren to close the first WEEKDAY. Try this:

=IF(WEEKDAY([Calendar Date]@row) = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))

Mark

Mark Cronk

Hi @Kelsey Ciarrocca ,

Try:

=IF(WEEKDAY([Calendar Date]@row = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))

Mark

Kelsey Ciarrocca

https://community.smartsheet.com/discussion/comment/271531#Comment_271531

Hi @Mark Cronk , I tried this and got #INCORRECT ARGUMENT SET. Any other ideas? I tried changing what I had to @row, and I'm still getting the 0's.

Mark Cronk

Good evening @Kelsey Ciarrocca ,

It was missing a paren to close the first WEEKDAY. Try this:

=IF(WEEKDAY([Calendar Date]@row) = 1, "Sunday", IF(WEEKDAY([Calendar Date]@row) = 2, "Monday", IF(WEEKDAY([Calendar Date]@row) = 3, "Tuesday", IF(WEEKDAY([Calendar Date]@row) = 4, "Wednesday", IF(WEEKDAY([Calendar Date]@row) = 5, "Thursday", IF(WEEKDAY([Calendar Date]@row) = 6, "Friday", "Saturday"))))))

Mark

Kelsey Ciarrocca

@Mark Cronk THANK YOU!! That worked!

Mark Cronk

Happy to help. Thanks for using the Community.

Mark