Forum Discussion
excel_learner
Feb 07, 2024Brass Contributor
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
- JKPieterseSilver Contributor
- excel_learnerBrass ContributorWorked a treat
Thank you