Hi,
We have a spreadsheet at work I am trying to simply. In short, I use a long combined IF AND formula to do this. I am curious if there is a faster way and to automate it into VBA.
I need it to look at the "Main Date" and evaluate what happened. If "Main Date" falls within a SET with a start and end date then returns a value. If it falls outside all of the SETS then returns another value. If it encounters only 1 or multiple date SETS but, one lacks an end date, it looks at all the SETS and determines what happens.
Maybe the long IF AND statement is the best way, I just dont know
Thank you
We have a spreadsheet at work I am trying to simply. In short, I use a long combined IF AND formula to do this. I am curious if there is a faster way and to automate it into VBA.
I need it to look at the "Main Date" and evaluate what happened. If "Main Date" falls within a SET with a start and end date then returns a value. If it falls outside all of the SETS then returns another value. If it encounters only 1 or multiple date SETS but, one lacks an end date, it looks at all the SETS and determines what happens.
Maybe the long IF AND statement is the best way, I just dont know
Thank you
