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?