dayofyear to date

[DrWave]

Any idea how I can convert day of year to date ?

 

[NJDude]

Something like this:

Dim Year, Date As Long
Dim Day As Int
                        
Year = DateTime.DateParse("01/01/2012")
            
Day = 15
            
Date = DateTime.Add(Year, 0, 0, Day - 1)
            
Msgbox("The " & Day & "th day is " & DateTime.Date(Date), "")