View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default 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