Want to push data from one cell to another cell based on a defined length of time
Hi all,
Could someone please help me with a formula for pushing data from one cell to another cell based on a defined length of time. For example.
I have 2 people coming in for a visit in the month of january and i know they have a defined visit interval of coming back every 6 months after their visit. How could i get those 2 to autopopulate based on the formula in July and so on and so forth?
Thanks!
Assuming a date in A2 is the first visit and you wish the B2 to show the next visit for 6 months later on the same day:
=DATE(YEAR(A2), MONTH(A2)+6, DAY(A2))
If you wanted B2 to be blank until after the date in A2 had arrived, then this:
=IF(OR(A2<TODAY(), A2=""), "", DATE(YEAR(A2), MONTH(A2)+6, DAY(A2)))
Now, after entering that formula in B2, you could copy to the right and the formula would keep adding dates after the prior date had arrived.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Please see attached for better clarification of what I am trying to do.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed.
Manually mockup your desired results from the sample data for a complete row or two, use BEFORE/AFTER sheets if needed.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks