Thread
:
DayOfYear Function?
View Single Post
#
5
Posted to microsoft.public.excel.programming
Jake Marx[_2_]
external usenet poster
Posts: 23
DayOfYear Function?
Hi Joe,
This function should do that:
=A1-DATE(YEAR(A1),1,1)+1
--
Regards,
Jake Marx
MS MVP - Excel
Joe wrote:
Is there anyway to return the day number of the year. For example,
where 12/26/2003 would be = to 300.
Reply With Quote
Jake Marx[_2_]
View Public Profile
Find all posts by Jake Marx[_2_]