Forum Discussion
Solved
Excel 2016 on Windows 10 date calculations
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?
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 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 columnsHi. 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.
