Multiple Conditions - VBA


H

halpie97

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
 
Ad

Advertisements

D

Don Guillett Excel MVP

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top