Thread
:
Help Convert "MM/DD/YYYY" to "YY:DDD"
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Sam
Posts: n/a
Help Convert "MM/DD/YYYY" to "YY:DDD"
Hello,
Please help:
I have a column of dates in the MM/DD/YYYY" format
How can I convert it to the
"YY:DDD" format?
For example, 12/31/2005 would become 05:365 and
01/01/1985 would become 85:01
Thank you!
Reply With Quote