Gallery
WeekNumber, Weekday, & WeekdayName
Share
Explore

icon picker
WeekNumber, Weekday, & WeekdayName

Everything you need to know about how these formulas in Coda.io work
Formulas: WeekNumber(), Weekday(), and WeekdayName()
Category: Dates/Times
week-view.svg
WeekNumber()
saturday.svg
Weekday()
tuesday.svg
WeekdayName()
Returns the week number of a date; Jan 1st returns “1”
Another way to say it...
Hey Coda, here’s a date. Which week of the year does this land on?
Returns the number of the weekday of a given date
Or, as one might say...
Hey Coda, here’s a date. As a number, what day of the week is this?
Returns the date as the text of the day of the week
Said differently...
Hey Coda, here’s a date. What day of the week does it fall on?

All three formulas each have one parameter.
overtime (1) (3).svg
DateTime

(DateTime)

The date you want to work with.


Choose any date:
Mar 15, 2023

WeekNumber:
11
The date you chose is week number
11
/52 for the total year. This much of the year has already passed.
00
11

WeekDay:
4
The date you chose falls on a
Wednesday
which is the
4th
day of the week.
Notice, though, that this is only true if you consider Sunday the first day of the week. If Monday is the first day of the week for you, use IsoWeekDay()
WeekDayName:
Wednesday
Ever heard of before? No more wishing you were one!
Thanks to Coda we know that the date you chose falls on a
Wednesday
!

idea

Localization in Coda

In the United States, Sunday is counted as the first day of the week. In other countries, it is common for Monday to be counted as the first day of the week.
For those of you living in a Country where Monday is the first day of the week, WeekDay() will be a useless formula for you without adding a -1 to the result. Use IsoWeekDay() instead.
Having formulas (and other things like currencies, time, right-to-left language support, etc.) support how other countries and cultures display and understand data is called localization.
There have been many requests for further localization within Coda, and while some strides have been made, there are still lots of improvements Coda can make to support non-US users.

Click into any of the cards below to try you hand at using these formulas! Be careful though, the challenge is rather difficult!
Done
Determine your most productive days of the week in a graph
Done
Done

Ready to master Coda yourself?

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.