 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

### Coda Native

272
`=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.22
`=min(max((Today()-date(today().Year(),1,0))/(EndOfMonth(date(today().Year(),12,1), 0)-date(today().Year(),1,0)),0),1)`

0000
0.65
`=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)`

### Day Progress Pack

79
`=DayOfYear(Today())`

365
`=DaysInYear([year select])`

31
`=DaysInMonth([month and year select])`

0000
0.22
`=YearProgress(Today())`

0000
0.65
`=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:
0
`=MonthProgress(today(),[month select])` 