Hey gang...
I am just wanting to copy and paste a formula that holds a certain cell in the formula.
Basically
Column A conains arrival (100 year date)
Column B contains departure (100 year date)
Column C through HH contain a header date (June 1 through Dec 31,2008)
I am basically going to use a IF((AND)) statement to put a 1 in the column matching the date when someone is staying
How can copy the fomula across all the columns and hold the fact that the formula dates change but the cells referneced in the statement stay (always looking at column A and B) So the A3 and the B3 stay in each formula but both 39652 in column C go to 39653 in D, 39654 in E and so on.
=IF((AND(A3<=39652,B3>39652)),1,0)
I am just wanting to copy and paste a formula that holds a certain cell in the formula.
Basically
Column A conains arrival (100 year date)
Column B contains departure (100 year date)
Column C through HH contain a header date (June 1 through Dec 31,2008)
I am basically going to use a IF((AND)) statement to put a 1 in the column matching the date when someone is staying
How can copy the fomula across all the columns and hold the fact that the formula dates change but the cells referneced in the statement stay (always looking at column A and B) So the A3 and the B3 stay in each formula but both 39652 in column C go to 39653 in D, 39654 in E and so on.
=IF((AND(A3<=39652,B3>39652)),1,0)