Thread: How do I convert dd/mm/yy date format to yyddd Julian date format
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How do I convert dd/mm/yy date format to yyddd Julian date format
Here is yet another way (one function call less than the other posted
formulas)...

=RIGHT(YEAR(A1)*1000+A1-DATE(YEAR(A1),1,0),5)

And if you are willing to trade a function call for a concatenation, we can
reduce the formula by yet another function call...

=RIGHT(YEAR(A1)*1000+A1-("1/1/"&YEAR(A1))+1,5)

--
Rick (MVP - Excel)


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

Reply With QuoteReply With Quote