If I have the year and the number of days in that year, how can I know the date?

Hi,

Use the DateSerial function as it always return a valid date.
If parameters are out of "traditional" values, the result will be adjusted.

Sample code:

Dim theYear As Integer
theYear = 2018

Dim theDay As Integer
theDay = 45

Dim dt As Date
dt = DateSerial(theYear, 1, theDay)

Select allOpen in new window

I don't have the month. I have the number of days from the start of the year.

into a cell. then have a cell = 1/1/yy + (days-1)
this will be the date for that number of days in year yy.
if you have

year = 2018
daynumber = 20
stryear= "01-Jan-" + year.tostring()
DateAdd("d", daynumber, stryear)

Select allOpen in new window

thank you so much

you don't need the month we hardcode the month as 1 then add days to that.