Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel date formula question

Old 12-08-06, 08:24 AM
  #1  
DVD Talk Platinum Edition
Thread Starter
 
Join Date: May 2001
Location: In my Home Theater- Foley, AL
Posts: 3,503
Excel date formula question

I want to input a date in one cell and have it automatically enter another date six months ahead in another cell.

Example:

I enter 12/08/06 in A2

Excel automatically enters 05/08/06 in B2

How can I do this?

Thank you!

Sonic
Sonicflood is offline  
Old 12-08-06, 09:02 AM
  #2  
DVD Talk Limited Edition
 
Dr. Henry Jones, Jr.'s Avatar
 
Join Date: Jun 2005
Location: My Car
Posts: 6,752
you would enter this code in B2:

Code:
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
Dr. Henry Jones, Jr. is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.