Month year formula
Closed
martina
-
Jan 5, 2011 at 07:24 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 6, 2011 at 08:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 6, 2011 at 08:08 PM
Related:
- Month year formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
4 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jan 6, 2011 at 09:56 AM
Jan 6, 2011 at 09:56 AM
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
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
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 6, 2011 at 04:44 AM
Jan 6, 2011 at 04:44 AM
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))
(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
Is it still the same formula? Sorry if i mislead you, was a typing error.
Regards,
Martina
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 6, 2011 at 08:08 PM
Jan 6, 2011 at 08:08 PM
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.
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.
