=TODAY()-DATE(2007,1,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jimmy B" <Jimmy wrote in message ...
| Is it possible to get Excel 2003 to display a date as the day of the year?
| For instance, today is 4-6-07, the 96th day of the year. How can I get the
| spreadsheet to display 96?