|
convert Numbers to Dates
Is it Possible to Convert Mentioned Below Number to Dates
In mm-dd-yyyy Format Dates 29082009 31082009 05092009 07092009 08092009 09092009 07112009 25082009 11092009 08092586 08092586 09082009 27082009 27082009 27082009 29082009 31082009 24104889 05092009 10092009 09032009 09052009 09092009 25082009 26082009 29082009 29082009 29082009 24104889 24104889 21097627 07092009 12092009 14092009 14092009 14092009 28082009 08092009 29082009 31082009 08092586 08092586 28102668 09032009 09042009 09092009 09092009 09102009 09102009 09112009 09112009 08092586 12062641 28102668 28102668 18122750 09022009 09022009 09032009 05052009 15032696 18122750 09032009 09042009 9122009 7092009 12092009 12092009 14092009 25--08-09 25--08-09 25--08-09 25--08-09 28--08-09 29--08-09 29--08-09 24104889 24104889 21097627 21097627 3092009 5092009 5092009 5092009 7092009 7092009 7092009 7092009 7092009 8092009 8092009 8092009 8092009 9092009 9092009 9092009 10092009 10092009 11092009 11092009 11092009 12092009 14092009 12062641 9092009 16102285 28082009 24104889 25082009 29082009 4092009 9092009 11092009 12092009 12092009 14092009 14092009 28072009 27072009 4082009 26082009 31082009 11092009 12092009 25082009 29082009 31082009 5th sept 09 14092009 9112009 29082009 9012009 9052009 9102009 9102009 9102009 14092009 14092009 25082009 26082009 26082009 29082009 31082009 9042009 9042009 9052009 9072009 9092009 14092009 14092009 14092009 14092009 18122750 09032009 26082009 27082009 19052009 06042009 06072009 19062009 22062011 29062009 29062009 07032009 07082009 13072009 14072009 15072009 20072009 23072009 26072009 26072009 26072009 28072009 28072009 28072009 28072009 29072009 31072009 08022009 08022009 08042009 08072009 08122009 14082009 14082009 17082009 20082009 29088219 25082009 26082009 28082009 30082009 31082009 31082009 09072009 09072009 09072009 09092009 14092009 |
convert Numbers to Dates
Either:
=DATE(RIGHT(A2,4),MID(A2,3,2),LEFT(A2,2)) and custom format cell as mm-dd-yyyy or =TEXT(DATE(RIGHT(A2,4),MID(A2,3,2),LEFT(A2,2)),"mm-dd-yyyy") Note that the former has the advantage of that it remains a number (easy to compare, and my preferred method of handling dates) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Hardeep kanwar" wrote: Is it Possible to Convert Mentioned Below Number to Dates In mm-dd-yyyy Format Dates 29082009 31082009 05092009 07092009 08092009 09092009 07112009 25082009 11092009 08092586 08092586 09082009 27082009 27082009 27082009 29082009 31082009 24104889 05092009 10092009 09032009 09052009 09092009 25082009 26082009 29082009 29082009 29082009 24104889 24104889 21097627 07092009 12092009 14092009 14092009 14092009 28082009 08092009 29082009 31082009 08092586 08092586 28102668 09032009 09042009 09092009 09092009 09102009 09102009 09112009 09112009 08092586 12062641 28102668 28102668 18122750 09022009 09022009 09032009 05052009 15032696 18122750 09032009 09042009 9122009 7092009 12092009 12092009 14092009 25--08-09 25--08-09 25--08-09 25--08-09 28--08-09 29--08-09 29--08-09 24104889 24104889 21097627 21097627 3092009 5092009 5092009 5092009 7092009 7092009 7092009 7092009 7092009 8092009 8092009 8092009 8092009 9092009 9092009 9092009 10092009 10092009 11092009 11092009 11092009 12092009 14092009 12062641 9092009 16102285 28082009 24104889 25082009 29082009 4092009 9092009 11092009 12092009 12092009 14092009 14092009 28072009 27072009 4082009 26082009 31082009 11092009 12092009 25082009 29082009 31082009 5th sept 09 14092009 9112009 29082009 9012009 9052009 9102009 9102009 9102009 14092009 14092009 25082009 26082009 26082009 29082009 31082009 9042009 9042009 9052009 9072009 9092009 14092009 14092009 14092009 14092009 18122750 09032009 26082009 27082009 19052009 06042009 06072009 19062009 22062011 29062009 29062009 07032009 07082009 13072009 14072009 15072009 20072009 23072009 26072009 26072009 26072009 28072009 28072009 28072009 28072009 29072009 31072009 08022009 08022009 08042009 08072009 08122009 14082009 14082009 17082009 20082009 29088219 25082009 26082009 28082009 30082009 31082009 31082009 09072009 09072009 09072009 09092009 14092009 |
convert Numbers to Dates
=DATE(RIGHT(A1,4),LEFT(RIGHT(A1,6),2),LEFT(TEXT(A1 ,"00000000"),2))
with the proper format. -- Gary''s Student - gsnu200903 |
convert Numbers to Dates
Man you both are Life Saver
Thanks Both of you Regards Hardeep kanwar "Gary''s Student" wrote: =DATE(RIGHT(A1,4),LEFT(RIGHT(A1,6),2),LEFT(TEXT(A1 ,"00000000"),2)) with the proper format. -- Gary''s Student - gsnu200903 |
| All times are GMT +1. The time now is 03:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com