Question: how to use excel to calculate number of weeks?
Answer: Type your first date in cell A1.
Type your second date in cell A2.
Type "=INT((A2-A1)/7)" in cell A3 to calculate the number of weeks.