up vote 2 down vote favorite
share [g+] share [fb]

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?

link|improve this question
96% accept rate
feedback

1 Answer

up vote 3 down vote accepted

=TODAY() + 7*12

or in general,

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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