Excel 2016 on Windows 10 date calculations

Occasional Contributor

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?

3 Replies
best response confirmed by Beepee2021 (Occasional Contributor)

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

You can drag the formula for the next columns


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

Thank-you again


I just ask you please to flag it as solved.