Thread: convert day of year to numeric value format year+day in 4 digits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kaaren Kaaren is offline
external usenet poster
  
Posts: 1
Default convert day of year to numeric value format year+day in 4 digits
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