DayOfYear Function?
Joe wrote:
Is there anyway to return the day number of the year. For example,
where 12/26/2003 would be = to 300.
With a simple formula, you could do something like this, assuming 12/26/2003
was in A1:
=A1-DATE(YEAR(A1),1,1)+1
--
Dianne
|