Calculating the Difference Between Two Dates in Weeks in Microsoft Excel

1. Subtract the prior date from the current date to get the difference in days:
   Formula:

   =TODAY()-A2 

2. Convert the difference in days to weeks by dividing by 7:
   Formula:

   =(TODAY()-A2)/7 

3. 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.