Forum Discussion

excel_learner's avatar
excel_learner
Brass Contributor
Feb 07, 2024
Solved

Converting date into year and month

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

Resources