Converting date into year and month

[excel_learner]

Hi

i am trying to retrieve a date and show as year and month an example of this is 2021-05

I want the year and month to show as April being the first month of the year.

for example if there is a date in as 15/01/2022

I want it to show in period column as 2021-10 

How do i go about this?

Thank you

[#2 · Accepted solution]

@excel_learner Something like this maybe?

=TEXT(DATE(YEAR(A1),MONTH(A1)-3,1),"yyyy-mm")

[#3]

Worked a treat
Thank you