I'm trying to create a Validation List that shows a drop-down with three
years worth of dates before and after today's date.

Currently I am using a 2100 row list of manually inputted dates in a
separate worksheet but that just gets cumbersome when I have to constantly
update the date range named "Calendar Dates"

Does anyone know if there is there some sort of Function or code that can do
this dynamically without using 2100 rows?

I'm thinking that sheet3 cell A3 has today's date, A2 has a calculated
back-off date that goes backwards to 365*3 and then the same for A4 but it
goes forwards.

Just Hoping.

Thanks In Advance,
Rob