Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with added days | Excel Discussion (Misc queries) | |||
Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS | Excel Programming |