Share
Explore

icon picker
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
2013
Month select:
00
0
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
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:
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

=DayOfYear(Today())



365
=DaysInYear([year select])



31
=DaysInMonth([month and year select])

0
=YearProgress(Today())





0
=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
=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:
0
=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.