Date formula in excel
Closed
binu
-
27 Aug 2009 à 23:56
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Aug 2009 à 21:05
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Aug 2009 à 21:05
Related:
- Date formula in excel
- Formula to calculate vat in excel - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Grade formula in excel marksheet - Guide
- Number to words in excel formula - Guide
- How to change date format in excel - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
28 Aug 2009 à 21:05
28 Aug 2009 à 21:05
formula is required if the data was ENTERED ALREADY as 28/8/09
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
28 Aug 2009 à 07:03
28 Aug 2009 à 07:03
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.
