PS Why does this formula yield '38420' instead of '259'?:
=DAYS360(1/1/2006,TODAY(),FALSE)

1/1/2006 is the equivalent of 1 divided by 1 divided by 2006

Try it this way:

=DAYS360("1/1/2006",TODAY(),FALSE)

Based on a 365(6) day year:

=TODAY()-DATE(YEAR(TODAY()),1,1)+1

Format as GENERAL

Biff

"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)