Help Convert "MM/DD/YYYY" to "YY:DDD"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...


=TEXT(A1,"yy")&":"&TEXT(A1-DATE(YEAR(A1),1,0),"00")


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
converting dd/mm/yy to mm/dd/yyyy 3
convert 13.11.2009 general to 13/11/2009 date, how to 1
Date format problems after csv import 2
Getting MM-DD HH:MM out of Julian date 4
Excel is seeing the date as dd/mm/yyyy 4
Arranging dates in a single column 5
Converting mm/dd/yyyy to yyyy/mm/dd 6

Back
Top