16

How can a given number of weeks be added to the current date in Excel 2007? For example, if I need to add 12 weeks to the current date, 12/6/2010, how can that be done?

24

=TODAY() + 7*12

or in general,

=TODAY() + 7*(no of weeks)

| improve this answer | |
  • If you are getting a number instead of a date (like I was), change the cell formatting to Date type. – RozzA Mar 10 '17 at 2:09
  • Tahnk you, your answer is appriciated even ten years after you gave it. – Sandra May 2 at 11:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.