Share
Explore

# Coda vs Day Progress Pack ComparisonCoda 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

62
=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())