Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
Copy multiple collumns with multiple conditions. | Excel Programming | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |