Using DATE/YEAR function, for last year

[mdperry8190]

I have a formula to spit out certain dates, for example:

=DATE(YEAR(TODAY()),1,1)

will return 1/1/2025

and

=DATE(YEAR(TODAY()),6,26)

will return 6/26/2025.

How do I get it so that it will automatically set it to that date for the previous year? When I open the spreadsheet, I want it to automatically set those dates for 2024 for now, but set them as 2025 when it is opened next year.

 

[Sergius]

Hello! Is this what you wanted?

=DATE(YEAR(TODAY())-1,6,26)