Hi, I am trying to add 14 days to a date....10/1/07 plus 14days = 10/15/07, I
know this is simple but I just cant get it....please help

If the date is in cell A1 then:

=DATE(YEAR(A1),MONTH(A1),DAY(A1)+14)

--
Gary''s Student - gsnu200748


"hannatrip" wrote:

> Hi, I am trying to add 14 days to a date....10/1/07 plus 14days = 10/15/07, I
> know this is simple but I just cant get it....please help

Make sure your date is a real Excel date, not text. You can check with the ISTEXT function.
If it is text, format as date AND re-enter the date (F2, ENTER)
If it is a real Excel date, just add 14 to it and make sure the resulting cell is formatted as date.
Like =A1+14

To learn more about calculating with dates, look here:

http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"hannatrip" <(E-Mail Removed)> wrote in message news67FEF28-1742-4FF3-936B-(E-Mail Removed)...
| Hi, I am trying to add 14 days to a date....10/1/07 plus 14days = 10/15/07, I
| know this is simple but I just cant get it....please help

Thanks!! your awesome!!

"Gary''s Student" wrote:

> If the date is in cell A1 then:
>
> =DATE(YEAR(A1),MONTH(A1),DAY(A1)+14)
>
> --
> Gary''s Student - gsnu200748
>
>
> "hannatrip" wrote:
>
> > Hi, I am trying to add 14 days to a date....10/1/07 plus 14days = 10/15/07, I
> > know this is simple but I just cant get it....please help