Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 4th 12, 04:27 AM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 1
Default Autopopulating a date

I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically give me the date 3 months from the date in A1. I have another date in C1 and I want to automatically populate the date 6 months later in D1.

I want to be able to enter different dates in the A column with the corresponding date to follow in the B column automatically.

Can anyone help?

  #2   Report Post  
Old May 4th 12, 07:50 PM
Senior Member
 
First recorded activity by ExcelBanter: Jul 2010
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by KellyJane View Post
I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically give me the date 3 months from the date in A1. I have another date in C1 and I want to automatically populate the date 6 months later in D1.
I want to be able to enter different dates in the A column with the corresponding date to follow in the B column automatically.
Can anyone help?
<<<<< HELP from BRAZIL

Dear KellyJane, Good Afternoon.

Im not sure if I understood corretly your question.
But try this one:

_________A___________B__________C___________D_____
1___Initial Date____3 Months____Other Date____6 Months
2___01/01/2012___=Formula 1___01/10/2012__=Formula 2
2___01/01/2012___01/04/2012___01/10/2012__01/04/2013


Formula 1 -- B2 -- =IF(A2="","",EDATE(A2,3))
Formula 2 -- D2 -- =IF(C2="","",EDATE(C2,6))

Tell me if it worked for you.

Fell free to ask anything about your doubt.

Have a nice day.
__________________
I hope it can help you.

Best regards,
Marcilio Lobo
---------------------------
Belo Horizonte, Brazil
  #3   Report Post  
Old May 5th 12, 03:23 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2011
Posts: 829
Default Autopopulating a date

"KellyJane" wrote:
I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically
give me the date 3 months from the date in A1.


In B2: =EDATE(A1,3).

If you are using Excel 2003, EDATE is part of the ATP, an add-in which must
be installed and enabled.

If you cannot use EDATE, the following is equivalent:

=MIN(DATE(YEAR(A1),3+MONTH(A1),DAY(A1)), DATE(YEAR(A1),4+MONTH(A1),0))




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autopopulating formulass horizontally? Leonhardtk Excel Worksheet Functions 4 June 22nd 09 11:54 PM
date in Cell to change colors if the date is beyond today's date Pete Elbert Excel Discussion (Misc queries) 2 June 6th 09 06:31 AM
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 25th 07 12:05 AM
copy date based on date -refer to date range mindpeace[_4_] Excel Programming 1 June 3rd 06 01:30 PM
Need help autopopulating next new record with previous record data Harry S[_3_] Excel Programming 2 October 1st 03 10:59 PM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017