Explore

Coda vs Day Progress Pack Comparison

Look how easy the Day Progress Pack makes these formulas

Today’s day of year:

Days in a year:

Year select:

0000

⁠

Days in a month:

⁠

March 2023

⁠

Progress in a year:

Progress in a month:

Various overflow cases relative to a selected month and year:

Year select:

0000

2013

⁠

Month select:

⁠

Range of dates as an array:

Coda Native

⁠

218

⁠

=ToNumber(Today()-Date(today().year(), 1, 0))

⁠

366 days

⁠

=date([year select],13,0)-date([year select],1,0)

⁠

31

⁠

=EndOfMonth([month and year select], 0).day()

⁠

0000

0.17

⁠

=min(max((Today()-date(today().Year(),1,0))/(EndOfMonth(date(today().Year(),12,1), 0)-date(today().Year(),1,0)),0),1)

⁠

0000

0.06

⁠

=Today().Day()/EndOfMonth(Today(), 0).Day()

0 if the given date is before a selected year or 1 if the given date is after a selected year, between 0 and 1 if the given date is in a selected year:

⁠

=min(max(1-(Today()-date([year select 2],1,1))/(EndOfMonth(date([year select 2],12,1), 0)-date([year select 2],1,1)+1),0),1)

0 if the given date is before a selected month and year or 1 if the given date is after a selected month and year, between 0 and 1 if the given date is in a selected month and year:

⁠

=min(max((Today()-date([year select 2],[month select],0))/(EndOfMonth(date([year select 2],[month select],1), 0)-date([year select 2],[month select],0)),0),1)

0 if the given date is before a selected month in the given date’s year or 1 if the given date is after a selected month in the given date’s year, between 0 and 1 if the given date is in a selected month:

⁠

=min(max((Today()-date(today().year(),[month select],0))/(EndOfMonth(date(today().year(),[month select],1), 0)-date(today().year(),[month select],0)),0),1)

Not really available

Day Progress Pack

⁠

=DayOfYear(Today())

⁠

365

⁠

=DaysInYear([year select])

⁠

31

⁠

=DaysInMonth([month and year select])

⁠

=YearProgress(Today())

⁠

=MonthProgress(today())

0 if the given date is before a selected year or 1 if the given date is after a selected year, between 0 and 1 if the given date is in a selected year:

⁠

=YearProgress(Today(),[year select 2])

0 if the given date is before a selected month and year or 1 if the given date is after a selected month and year, between 0 and 1 if the given date is in a selected month and year:

⁠

=MonthProgress(Today(),[month select],[year select 2])

⁠

=MonthProgress(today(),[month select])

⁠

=DatesInRange(today()-7, today())

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.