You could use WEEKNUM:
=WEEKNUM(A2)-WEEKNUM(A3)

It should all work about the same. Your original idea is probaly easier to
understand.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Ayo" wrote:

Is there a function that calculates the number of weeks between two dates? Or
am I going to have to use (A2-A3)/7.