Multiple Conditions - VBA
 

Need some help with VBA.

I have two columns each with dates (see below). I'm looking for a VBA
function that will look at each date and provide another date based on
the following criteria: It needs to first look at Column B and
figure out 180 days from that date, then compare that value to Column
C to ensure that the date is still 180 days from Column C, if not,
then calculae that date. Basically I'm looking for a multi function
conditional formula that will get me a date in Column D that is always
180 days from Column A, B, C based on the inputs into each cell.


Column A Column B Column C Column D
7/10/09 6/30/10 (1 year from Column A) (insert value
from VBA)
9/1/10 3/31/10

Multiple Conditions - VBA
 

On Oct 29, 7:41*am, halpie97 wrote:
Need some help with VBA.

I have two columns each with dates (see below). *I'm looking for a VBA
function that will look at each date and provide another date based on
the following criteria: * It needs to first look at Column B and
figure out 180 days from that date, then compare that value to Column
C to ensure that the date is still 180 days from Column C, if not,
then calculae that date. *Basically I'm looking for a multi function
conditional formula that will get me a date in Column D that is always
180 days from Column A, B, C based on the inputs into each cell.

Column A * * * * Column B *Column C * * * * * * * * * * *Column D
7/10/09 * * * * * * 6/30/10 * * (1 year from Column A) * (insert value
from VBA)
9/1/10 * * * * * * *3/31/10

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."