Excel 2016 on Windows 10 date calculations

[Beepee2021]

I want to display a range of year dates (as in tax years) 20/21 21/22 22/23 in column headers.

Is it (easily) possible to display as above but calculate from a fixed start date say 1 Jan 2020?

[#2 · Accepted solution]

Considering the first date 1 Jan 2020 in Cell A1 you can type the following formula in Cell C1
=YEAR(A1)&"/"&YEAR(A1)+1
On Cell D1 the formula =RIGHT(C1,4)&"/"&RIGHT(C1,4)+1

You can drag the formula for the next columns

[#3]

@Juliano-Petrukio 

Hi. Thanks that looks fairly straightforward. I shall go and play. 

Thank-you again

Beepee

[#4]

Great.
I just ask you please to flag it as solved.