Date formula in excel

Closed
binu - Aug 27, 2009 at 11:56 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 28, 2009 at 09:05 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 28, 2009 at 09:05 PM
formula is required if the data was ENTERED ALREADY as 28/8/09
1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 28, 2009 at 07:03 AM
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.
0
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.
0