Custom Year column between dates

[Anonymous]

Hi, 

I need to create a custom Year column based on between dates

Between

01/09/2014 and 31/08/2015 then 14/15 else

01/09/2015 and 31/08/2016 then 15/16 else

01/09/2016 and 31/08/2017 then 16/17 else

01/09/2017 and 31/08/2018 then 17/18 else

01/09/2018 and 31/08/2019 then 18/19 else

01/09/2019 and 31/08/2020 then 19/20 else

01/09/2020 and 31/08/2021 then 20/21 else

01/09/2021 and 31/08/2022 then 21/22 else

01/09/2022 and 31/08/2023 then 22/23 else

any idea what the correct syntax to use on this would be, please?

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

if(month([Date]) >=9 , format([Date], "YY") & "" & ((format([Date], "YY")*1)+1) ,((format([Date], "YY")*1)-1) & "" & format([Date], "YY") )

https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5ee47de6a208