Date formula in excel
Closed
binu
-
Aug 27, 2009 at 11:56 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 28, 2009 at 09:05 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 28, 2009 at 09:05 PM
Related:
- Date formula in excel
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- How to take screenshot in excel - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 28, 2009 at 09:05 PM
Aug 28, 2009 at 09:05 PM
formula is required if the data was ENTERED ALREADY as 28/8/09
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 28, 2009 at 07:03 AM
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.
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.
