Function to return date as number of the day in the year

V

vtj

I seem to remember seeing a function that would take any date and return the
number of the day in the year. Was/am I dreaming? If not could you please
point me to the function name? Thanks for your help!!
 
F

fredg

I seem to remember seeing a function that would take any date and return the
number of the day in the year. Was/am I dreaming? If not could you please
point me to the function name? Thanks for your help!!
Click to expand...

Look up the various arguments of the DatePart function in VBA help.

DatePart("y",[DateField])
 
Top