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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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])
 
Back
Top