How to calculate the number of calendar days between a date and the start of the year

DateDiff(“day”, MakeDate(Year([Date]), 1, 1), [Date])

The MakeDate portion of the formula creates the start date for the calculation by hard coding January 1 with the corresponding [Date]'s year.

If you want to get the total elapsed days, add 1 at the end of the formula:

DateDiff(“day”, MakeDate(Year([Date]), 1, 1), [Date]) + 1

1 Like

Great tip! Thank you for posting this.