Thanks:  0
Likes:  0

1. I'm working on an excel spreadsheet that contains dates. If I have a cell with a specific date, how could, by adding 6 months, have the next cell display the new date? What formula, procedure should I use to add dates?, in this case, add six months to the date on one cell?

2. This may not be perfect, but it is close:
If A1 contains the date:

=A1+DATEVALUE("7/1")

Tom

3. On 2002-04-27 18:29, gymwrecker wrote:
I'm working on an excel spreadsheet that contains dates. If I have a cell with a specific date, how could, by adding 6 months, have the next cell display the new date? What formula, procedure should I use to add dates?, in this case, add six months to the date on one cell?
Hi gymwrecker:
If your original date is in cell A2, then you can use the following formula ...

=EDATE(A2,6) to get a date 6 months later than that in cell A2.

HTH

4. On 2002-04-27 18:35, TsTom wrote:
This may not be perfect, but it is close:
If A1 contains the date:

=A1+DATEVALUE("7/1")

Tom
Hi Tom:
With your formula I got the right day, the right month, but year-wise it took me way way into the future!

Regards!

Yogi Anand

5. Hi gymwrecker and Tom:
I could use a more straightforward formula ...

=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))

I still have to figure out the basis for Tom's suggestion though.

6.

7. I figured that there was a function to do this...

This is what I originally had

=A1+DATEVALUE("7/1/1900")

Not

=A1+DATEVALUE("7/1/")

seeing that it would default to the current year and become the equivelant of :

=A1+DATEVALUE("7/1/2002")

Seems to work though...

Tom

8. seeing that it would default to the current year and become the equivelant of :

=A1+DATEVALUE("7/1/2002")

Seems to work though...

Tom
Hi Tom:
Let us try with today's date in cell A1 ... that would be
=today()

now if I add the date in cell A1 and datevalue("7/1/2002")

=today()+datevalue("7/1/2002")

you will notice that I get 10/27/2104

that's what I meant earlier by way way into the future. The day comes out right, the month comes out right, but not the year.

Regards!

Yogi Anand

[ This Message was edited by: Yogi Anand on 2002-04-27 19:11 ]

9. I have cell J2 with 09 Nov 01, how could I make cell J3 read 09 May 02, J2 + 6 months?
I have tried all your given formulas, but none have worked so far! Thanks for your replies.

10. what about if a1 has the date
=a1+183

that help

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•