I want to do a formula in G2 that states if E2 is between 2 dates then add E2 +85 and if it isn't between those two dates check if F2 is between same 2 dates. if F2 is then add F2 +85. if not, then leave G2 blank.

On top of that i want it to go to the next worksheet if it is the end of 2010 (i.e., put the same things in the 2011 worksheet so it carries on)
thanks