Formula for finding the first and last days of a year

jwestberry83396

I need to be able to calculate the first and last days of the year based upon the current date. Can someone help me out?

L_123

You don't really need to update anything other than the year right?

 

=date(year(today()),1,1) is the first day of the year

=date(year(today()),12,31) is the last day of the year

jwestberry83396

Correct,

Perfect, Thank you!