H
halpie97
I'm a beginner with VBA and looking for some guidance in how to
establish what I'm trying to do.
Column A Column B Column C Column D
1/15/2010 6/30/2009
3/2/2010 4/15/2008
I'm trying to create a VBA formula that will do the following in
columns C and D:
Column C should just be one year from Column A and insert the new
date.
Column D should be 180 days from Column B only if the date in Column
A
is less than 180 days and column B is greater than Column B.
(Bascially trying to create a schedule for a date stamp of one year
from Column A and then 180 dats from Column B but not if Column A
happened within the 180 days).
I'm looking for the function to insert the calcuated date value in
both columns C and D for future reference.
I have tried to create this function with nested if statements, but
its too many statements, so I know VBA is the only way to go.
Thanks in advance for the help.
establish what I'm trying to do.
Column A Column B Column C Column D
1/15/2010 6/30/2009
3/2/2010 4/15/2008
I'm trying to create a VBA formula that will do the following in
columns C and D:
Column C should just be one year from Column A and insert the new
date.
Column D should be 180 days from Column B only if the date in Column
A
is less than 180 days and column B is greater than Column B.
(Bascially trying to create a schedule for a date stamp of one year
from Column A and then 180 dats from Column B but not if Column A
happened within the 180 days).
I'm looking for the function to insert the calcuated date value in
both columns C and D for future reference.
I have tried to create this function with nested if statements, but
its too many statements, so I know VBA is the only way to go.
Thanks in advance for the help.