Weeks between two Dates
 

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

Weeks between two Dates
 

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.

Weeks between two Dates
 

Thanks PJ.

"PJFry" wrote:

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.

Weeks between two Dates
 

Be careful if those two dates don't fall in the same year.

Ayo wrote:

Thanks PJ.

"PJFry" wrote:

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.

--

Dave Peterson