Question: how to calculate number of weeks between two dates in excel 2007?
Answer: Tips: If you want to get the number of full weeks between two dates, please apply this formula: =ROUNDDOWN((DATEDIF(A2, B2, "d") / 7), 0) =INT((B2-A2)/7)