Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community
SOLVED

Converting date into year and month

Brass Contributor

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 Replies
best response confirmed by excel_learner (Brass Contributor)
Solution

@excel_learner Something like this maybe?

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

 

 

Worked a treat
Thank you
1 best response

Accepted Solutions
best response confirmed by excel_learner (Brass Contributor)
Solution

@excel_learner Something like this maybe?

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

 

 

View solution in original post