On Tue, 22 Feb 2005 16:36:43 -0800, "Mark Scholes"
wrote:

Hi,
I have a date which is a sunday and I need to find how
many sundays it is from the begining of the year.

Thanks MarkS

OOPS.

My formula should be:

=DATE(YEAR(A1),1,8)-WEEKDAY(DATE(YEAR(A1),1,7))


--ron