Thread: show date as day of the year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default show date as day of the year
Try this

=A1-DATE(YEAR(A1),1,0)

date in A1 and format as general


Mike

"Brad" wrote:

i would like to show jan 1st is 1, or 8/2 is 214 ect

whats the function??

thanks
brad
Reply With QuoteReply With Quote