WeekNumber, Weekday, & WeekdayName
WeekNumber, Weekday, & WeekdayName
Everything you need to know about how these formulas in Coda.io work
Formulas: WeekNumber(), Weekday(), and WeekdayName()
Category: Dates/Times
WeekNumber() 
Weekday() 
WeekdayName()Returns the week number of a date; Jan 1st returns “1”
Another way to say it...
Returns the number of the weekday of a given date
Or, as one might say...
Returns the date as the text of the day of the week
Said differently...
All three formulas each have one parameter.
DateTime
(DateTime)
The date you want to work with.
Choose any date: Mar 15, 2023
Mar 15, 2023
WeekNumber:
11
The date you chose is week number /52 for the total year. This much of the year has already passed.
11
00
11
WeekDay:
4
The date you chose falls on a which is the day of the week.
Wednesday
4th
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
Thanks to Coda we know that the date you chose falls on a !
Wednesday
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.
Practice: Find the week number, day and day name of today
Done
Determine your most productive days of the week in a graph
Done
Challenge: Create an advanced progress bar to show someone’s progress towards a goal vs. elapsed time
Done
Ready to master Coda yourself?
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.