Calculate Number of Weeks Formula

[gymwrecker]

Need help with a formula to calculate the number of weeks that have passed based on TODAY. I specifically need complete weeks.

A1 = 4/29/2018
A2 = ??? (Number of weeks) (Today - A1?)

Note: using MS Excel 2013

 

[Joe4]

Try:

=INT((TODAY()-A1)/7)

 

[DHayes]

Hi, I hope this will help.

=ROUNDDOWN((DATEDIF(A1, TODAY(), "d") / 7), 0)

 

[gymwrecker]

Joe4 & DHayes, Thank you! Both formulas work! Appreciate it!!!

 

[Joe4]

You are welcome.

 

[DHayes]

You are welcome.