Trevor,
I do not understand the A366 portion of the equation.
Thanks,
Jim J.

"Trevor Shuttleworth" wrote:

One way:

=INT(A366-DATE(YEAR(A366)-1,12,31))

Regards

Trevor


"Jim J." wrote in message
...
How can one determine the correct day of the year, based on a 365 day
year?
I can use 'DAYS360' to find the number of today's date
=DAYS360(1/1/2006,9/20/2006,FALSE) will yield '259'. But the actual day
number based on a 365 day year is 263. I don't care about a 360 days year
(I
don't live there!). Again, how can I calculate the actual day number
based
on a 365 day year?
PS Why does this formula yield '38420' instead of '259'?:
=DAYS360(1/1/2006,TODAY(),FALSE)