Question: how to calculate the number of weeks in excel?
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.