Solved: First day of the year last year

adam_mac · ‎08-25-2021

Hi, i am trying to write a simple formula that calculates the first day of the year last year. So it will always be the 01/01/"Prior Year"

So far i have got below, however this just is for this year. Any ideas what i am doing wrong?

First Day of Prior Year = DATE(YEAR(TODAY()),1,1)

Jihwan_Kim · ‎08-25-2021

Hi,

Please try the below.

First Day of Prior Year = DATE(YEAR(TODAY())-1,1,1)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim · ‎08-25-2021

Hi,

Please try the below.

First Day of Prior Year = DATE(YEAR(TODAY())-1,1,1)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

First day of the year last year