Yes it would, but that's still not what the OP asked for, Ruth.

For the 96th day of the year he wanted to see 96, not 07, so he needs
=A1-DATE(YEAR(A1),1,0)
--
David Biddulph

"Ruth" wrote in message
...
Sorry, I wasn't paying enough attention. Type "yy" instead of "yyyy" and
it
will give you the last 2 digits of the year
--
:)