Formula for last day of the year

Hello
Is there any formula to capture last day of the year? currently used a hardcode date for my formula, but I am looking for a method to automate it so that in a year change there is no issue. Thanks

maybe something like

workdays(today(),makedate(year(today())+1,1,1)-1)

1 Like

Does this work for every year automatically? or do I need to change it once the year has changed?

It should return the last day of the year automatically. Also you can do

workdays(today(),makedate(year(today()),12,31))

Hi,
You want to have the last day of the year or the latest day of the year related to your dataset
Regards