Calculating the Difference Between Two Dates in Weeks in Microsoft Excel
- Subtract the prior date from the current date to get the difference in days:
- Convert the difference in days to weeks by dividing by 7:
- Enter the formula in the cell next to the prior date to calculate the approximate age in weeks.
Note: This formula only gives an approximate age in weeks, rounding down to the nearest whole week. For a more precise age in weeks, use a more complex formula that takes into account the number of days remaining after dividing by 7.