View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Larry Larry is offline
external usenet poster
 
Posts: 159
Default How do I convert a month-date format to day number of the year?

I have a list of dates in the format Mar-15. I want to convert these to the
day number of the year. In a non-leap year, Mar-15 would be 74 (the 74th day
of the year) and Dec-31 would be 365. Have not yet found a way to do this in
Excel.