Formula to update a fixed date to current year.

[Excellent022]

I am developing a basic timeline with activities that should happen on fixed dates within the fiscal year. I'd like this spreadsheet to automatically update these dates based on the current year so that it can be used ongoing. So for example, in 2035 these activities will still be due 8/1, 9/1, etc. but the year should read 2035.

Current Year	2022​
Task Number	Task Name	Duration	Start Date of RFP Activity	Formula Column	End Date of RFP Activity	Formula Column
	RFP Period
	Kickoff Meeting	1	07/01/23
	RFP Requirements Development	7d	08/01/23		08/09/23
	RFP Drafting	14d	08/10/23		08/29/23
	RFP Internal Program Clearance	3d	08/30/23		09/01/23

 

[Joe4]

You could do something like this:

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

and that will always return 8/1 of the current year, whatever year you may be in.

Or if you want to pull it from a cell (like B2), then just use:

=DATE(B2,8,1)

 

[Excellent022]

You could do something like this:

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

and that will always return 8/1 of the current year, whatever year you may be in.

Or if you want to pull it from a cell (like B2), then just use:

=DATE(B2,8,1)

Both work. Thanks so much!

 

[Joe4]

You are welcome!
Glad I was able to help.