Thread: How do I convert dd/mm/yy date format to yyddd Julian date format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How do I convert dd/mm/yy date format to yyddd Julian date format
=TEXT(A1,"yy")&TEXT(A1-DATE(YEAR(A1),1,0),"000")
--
David Biddulph

"itzy bitzy" wrote in message
...
I have done this before, but can't remember how!


Reply With QuoteReply With Quote