calculate a date, 10 weeks after a set date

G

Guido Cole

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
 
J

JE McGimpsey

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

A1: <date>
B1: =A1+70

Format B1 as a date.
 
Top