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

 

[Gerald Higgins]

Does this make sense?

Not to me !

 

[Foxfire]

I did not quite understand this. Could you proivde an example

 

[mistrpeepers]

Sorry if this wasn't clear

Hi-

I have data that gets added into the following columns (same row) over the course of a few weeks. We would like to have the latest date entered in any one of those columns (again same row) show up in column S (again, same row).

So if i entered the latest date in column F, it would then appear in column S. It must be the latest date though.

Thanks for the help!

 

[Gerald Higgins]

Something like

=max(F1:R1)

and format as date

 

[mistrpeepers]

code

It is F, G, H, J, L, N, Q & R- not F:R.

So the value that gets entered in any of these columns would then go into column S.

Thanks again

 

[Gerald Higgins]

Oops, sorry, in that case

=max(F1,G1,H1,J1,L1,N1,Q1,R1)

 

[mistrpeepers]

code

Thanks Gerald-

2 more quick questions-

1) where do i place this code?

2) this code would only work with data being entered in row one, so how would i manipulate this code to work with all rows?

Thank you!

 

[lenze]

What Gerald posted is not code. It is a formula and would go in S1. Copy down as needed. If you really want a code approach, post back and we can assist you.

lenze

 

[mistrpeepers]

Thank you

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

Sorry if my questions are a bit elementary

Thanks again