Days added to a date
 

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

Days added to a date
 

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

Days added to a date
 

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 he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"hannatrip" wrote in message ...
| 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

Days added to a date
 

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