Month year formula

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,


I would like to put in month year formula, suppose i have 31/08/2010 and i would like it to appear as 2010-06. How do i do it? Please advice

4 replies

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Martina,

This is just a case of changing the cells format.
Select the cell with 31/08/2010.
Hit Ctrl+1 or right-click > cell properties.
On the number tab select the bottom option (manual?).
Now enter the format you would like to see.
In your case: yyyy-mm.

Best regards,
Trowa
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
A1 is 31/08/2010
(date entered accoriding to your regional configurations as dd/mm/yy


In that case

=IF(LEN(MONTH(A1))=1,YEAR(A1)&"-0"&MONTH(A1),YEAR(A1)&"-"&MONTH(A1))
Hi Venkat, thank you for your reply much appreciated. I meant to say if i have 31/08/2010 and would like it to appear as 2010-08. How do i do it?
Is it still the same formula? Sorry if i mislead you, was a typing error.
Regards,
Martina
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
Martina
You must be clear whether 31/08/2000 is a DATE ENTRY or a text entry. in some regional configuration date is entered as dd/mm/yy and in some as mm/dd/yy.
ONLY IF date is entered as DATE my formula will work. if it is text it will be another formula. please clarify.