How do I increment a date by a certain number of weeks?

LatestCraze · Dec 9, 2004

I am trying to add a certain number of weeks (4) to a date and have Excel
automatically calculate for me. Help?

Frank Kabel · Dec 9, 2004

Hi
=A1+7*4

Peo Sjoblom · Dec 9, 2004

=A1+(4*7)

where A1 holds the date

Regards,

Peo Sjoblom