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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I increment a date by a certain number of weeks? (https://www.excelbanter.com/excel-worksheet-functions/7723-how-do-i-increment-date-certain-number-weeks.html)

LatestCraze

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

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

Frank Kabel

Hi
=A1+7*4

--
Regards
Frank Kabel
Frankfurt, Germany

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

Peo Sjoblom

=A1+(4*7)

where A1 holds the date

Regards,

Peo Sjoblom

"LatestCraze" wrote:

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

All times are GMT +1. The time now is 05:30 AM.