Date Values

  • Thread starter Thread starter baffled
  • Start date Start date
B

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.....
 
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-----
 
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.
 
Back
Top