Dates Formula

[shternm]

I want a formula that will do this:

30-Jan + 2 Weeks=13 Feb

 

[Frank Kabel]

Hi
if 30-Jan is stored in cell A1 just enter
=A1+14
or
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+14)

format the resulting cell as date
HTH
Frank

 

[Bob Phillips]

If A1 has date of 30-Jan

=A1+14

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Roger Govier]

Either =DATEVALUE("30/01/2004")+14
or with 30/01/2004 in A1 =A1+14

 

[Norman Harker]

Hi shtemm!

If date is in A1 and number of weeks in B1

=A1+B1*7
Formatted as date

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.