Days added to a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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

| 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro adding rows 8
Find then highlight in yellow 6
Add Hours by Looping through Data Q 27
Count the highest number of days without “errors” 2
Assigning values to dates 7
Mid-Month function help 3
Need help creating a formula 18
Removing duplicates but leaving data on following rows 5

Back
Top