Excel 2016 on Windows 10 date calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-2729226%22%20slang%3D%22en-US%22%3EExcel%202016%20on%20Windows%2010%20date%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2729226%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20display%20a%20range%20of%20year%20dates%20(as%20in%20tax%20years)%2020%2F21%2021%2F22%2022%2F23%20in%20column%20headers.%3C%2FP%3E%3CP%3EIs%20it%20(easily)%20possible%20to%20display%20as%20above%20but%20calculate%20from%20a%20fixed%20start%20date%20say%201%20Jan%202020%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2729226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2729318%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20on%20Windows%2010%20date%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2729318%22%20slang%3D%22en-US%22%3E%3CP%3EConsidering%20the%20first%20date%201%20Jan%202020%20in%20Cell%20A1%20you%20can%20type%20the%20following%20formula%20in%20Cell%20C1%3CBR%20%2F%3E%3DYEAR(A1)%26amp%3B%22%2F%22%26amp%3BYEAR(A1)%2B1%3CBR%20%2F%3EOn%20Cell%20D1%20the%20formula%20%3DRIGHT(C1%2C4)%26amp%3B%22%2F%22%26amp%3BRIGHT(C1%2C4)%2B1%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20drag%20the%20formula%20for%20the%20next%20columns%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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

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

@Juliano-Petrukio 

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

Thank-you again

Beepee

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