Date Values

[baffled]

Can someone please help with a formula that will give the
number of Sundays between 2 entered dates, so that
further calculations can be performed on the result.
Thanks.....

 

[J.E. McGimpsey]

Take a look here:

http://cpearson.com/excel/DateTimeWS.htm#NumDOWPeriod

 

[ozzie]

See if this works for you:

start date in cell a1, finish date in cell b1, following
formula in c1

=ROUND(DAYS360(A1,B1)/7,0)

test numbers used:
10/1/03
10/31/03
4 sundays.


Hope this helps.

Ozzie
-----Original Message-----

 

[chops]

thanks, J.E. That should do it!

-----Original Message-----
Take a look here:

http://cpearson.com/excel/DateTimeWS.htm#NumDOWPeriod


.

 

[chops]

Thanks Ozzie. But I don't think this will work for say;
starting date Sunday 10/12/03 to finishing date Sunday
11/02/03? i.e. inclusive Sundays.