Thread: convert day of year to numeric value format year+day in 4 digits
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default convert day of year to numeric value format year+day in 4 digits
=--(YEAR(A1)-2000&TEXT(DAY(A1),"000"))


"Kaaren" wrote:

I want to convert the day of the year into the format of year then the 3
digit day value - so 9031 would be january 31 2009 - want to have Excel
automatically calculate based on current date.
Reply With QuoteReply With Quote