Date formula in excel [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

can u pls help me in getting a simple date formula in excel eg:28/8/2009 i need to convert it to 28-aug-2009

please can u help me on this

3 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
formula is required if the data was ENTERED ALREADY as 28/8/09
1
Thank you

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

CCM 2942 users have said thank you to us this month

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
why do you want to CONVERT it. why not just format it as you like

By the by in exel you should enter date as mm/dd/yy
your date should have been entered as 8/28/09

Suppose 28/8/09 is already entered by somebody else as a text (not as a date) (assuming 28/8/2009 is in A1)
in B1 copy paste this formula
=(MID(A1,4,1)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,2))+0
you will get a number. format this as date in any format.
Is a formula necessary.

You can just:
1. Right click on the cell with the date
2. Format cells
3. Go to "Number" tab
4. Date
5. In Type, choose "14-Mar-2001"

You can copy the format to any cells you want by using the "Format Painter" (icon that looks like a paint brush.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!