WeekNumber, Weekday, & WeekdayName

Explore

Gallery

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

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.

⁠

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.

⁠

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

Calendrical savants⁠

before? No more wishing you were one!

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.

⁠

Click into any of the cards below to try you hand at using these formulas! Be careful though, the challenge is rather difficult!

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?

⁠

Coda School Take your Coda formulas from "I can get by" to "I can do anything" with a fully interactive course designed to be taken at your own pace, with accountability and community built in. www.codaschool.io⁠

Gallery

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.

WeekNumber, Weekday, & WeekdayName

Choose any date: Mar 15, 2023⁠⁠

Localization in Coda

Ready to master Coda yourself?

Choose any date:
Mar 15, 2023
⁠
⁠