calculate a date, 10 weeks after a set date
 

I have a series of given dates in column 1; which formula should I use to
calculate automatically the dates, 10 weeks later, in column 2
--
Guido

calculate a date, 10 weeks after a set date
 

Since XL dates are just integer offsets from a base date:

A1: <date
B1: =A1+70

Format B1 as a date.

In article ,
Guido Cole wrote:

I have a series of given dates in column 1; which formula should I use to
calculate automatically the dates, 10 weeks later, in column 2

calculate a date, 10 weeks after a set date
 

Hi!

Just add 70:

A1 = some date
B1 = =A1+70

Biff

"Guido Cole" wrote in message
...
I have a series of given dates in column 1; which formula should I use to
calculate automatically the dates, 10 weeks later, in column 2
--
Guido