Solved: Adding Dates

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
285
Cell A1 is formatted "mmm./dd/yyyy" (Apr./27/2010)
In cell B1 if I put in formula "=A1+1" I get the "dd" added by one. (Apr./28/2010)
How would I formulate cell B1 to be "A1+1=next month? next year? (May./27/2010) or (Apr./27/2011)?

In short, how do I formula cell B1 to be A1 + month or day or year?
Thank you for your help.
 
Joined
Feb 8, 2010
Messages
40
Use the DATE() function which has arguments of year, month, day in that order.

For date + 1 month use:

Code:
=date(year(a1),month(a1)+1, day(a1))
For date + 1 year use:

Code:
=date(year(a1)+1,month(a1),day(a1))
HTH
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top