Weeks between two Dates

A

Ayo

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

PJFry

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

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

Ayo

Thanks PJ.

PJFry said:
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.
Click to expand...
 
Top