Share
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
0.
.
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
2013Month select:
00
0.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Range of dates as an array:
Coda Native
32
=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.09=min(max((Today()-date(today().Year(),1,0))/(EndOfMonth(date(today().Year(),12,1), 0)-date(today().Year(),1,0)),0),1)
0000
0.04=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:
0
1=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:
0
1=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:
0
1=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
32
=DayOfYear(Today())
365
=DaysInYear([year select])
31
=DaysInMonth([month and year select])
0000
0.09=YearProgress(Today())
0000
0.04=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:
0
1=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:
0
=MonthProgress(Today(),[month select],[year select 2])
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:
0000
0.04=MonthProgress(today(),[month select])
1/25/20251/26/20251/27/20251/28/20251/29/20251/30/20251/31/20252/1/2025
=DatesInRange(today()-7, today())
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.