Formulas on VBA

[amattey]

I have 3 columns in one sheet, The first one is a date formated (mm,dd,yyyy), the second one is an output column, and the third one is the input. I wanted to create a formula that will select whatever is in the third column as the input and if column 1 is 1 year less or 2 years after a date that is located in another ceel (different sheet), to say something like "Do this year". Could you advise in how to get started, I wrote something but even I looking at it does not make much sense.

 

[baitmaster]

This doesn't entirely make sense, but that should be ok - I just dont get what you are doing with Column C, your "input", and I'm also unsure what your date requirement is: 1 year before or 2 years after another date, is that right?

I guess you want to try something like

=if(OR(A1<[other date]-365,A1>[other date]+730),"perform action " & c1 & " this year","no action required")