Need a formula to add 2 weeks to a date...

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Could someone please help with a formula? What I would
like to do is have column A have a date, column B is
where I want the formula to pull the 1st columns date and
add 2 weeks to give me a new date. Is that possiable?
 
in b1...

=date(year(a1),month(a1),day(a1)+14)

this should do ya.

hope this helps. if you're going to be looking at dates, i'd look at
the analysis toolpak add-in for the added date functions (edate eomonth
and such).

HTH
 
Hi Sue,

In B1 enter
=A1+14
then fill down...

.... assuming there is an Excel *date* value in A1

HTH
Anders Silven
 
Back
Top