S
shternm
I want a formula that will do this:
30-Jan + 2 Weeks=13 Feb
30-Jan + 2 Weeks=13 Feb
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
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
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
B
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)
=A1+14
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
R
Roger Govier
Either =DATEVALUE("30/01/2004")+14
or with 30/01/2004 in A1 =A1+14
or with 30/01/2004 in A1 =A1+14
N
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.
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.