Having date that is entered in one column change dates

[mistrpeepers]

Hi all-

Need help with another task-
In tab 1, I am trying get column S to change to what any time date in column F, G, H, J, L, N, Q or R get changed to-

Does this make sense? Any help greatly appreciated

 

[tusharm]

Re: Thank you

Move the cursor to the right-bottom corner of S1. It will become a equi-sized cross. Double-click the mouse left button.

How do i get this formula to work throughout all rows though?

Sorry if my questions are a bit elementary

Thanks again

 

[lenze]

Because the formula is "Relative", Excel will adjust it automatically when you copy it down. So, in S2 it will become

=max(F2,G2,H2,J2,L2,N2,Q2,R2)

See the help files for a discussion on Absolute vs Relative cell references.

lenze

 

[mistrpeepers]

tusharm

I tried moving to bottom right and got the equal cross to come up- double left mouse button not doing anything- any ideas why this would be happening?

 

[Norie]

Because you have no data in an adjacent column?