Yah, I started there, but found that if one date is, say, on a Monday & the
other is on a Friday, this method does not give me the correct number of
weeks because of rounding down. I need something a little more exact. I
have had success with the WEEKNUM function when the two dates are in the same
year, but using dates in different years proves beyond my ken. Can you help?
For example, the number of weeks between 3-Oct-05 and 15-Oct-04.

b.

"Bob Phillips" wrote:

Simple way, subtract earlier date from later date and divide by 7. If you
want whole weeks, INT it or ROUND it

=(A2-A1)/7
=INT((A2-A1)/7)
=ROUND((A2-A1)/7,0)



--
HTH

Bob Phillips

"BobbiA" wrote in message
...
How can I find the number of weeks between two dates when they fall in
different years?