Transferring latest date from a row to another spreadsheet.

[Loadmaster]

How do I enter the date into a sheet called 'Currencies' cell D3, the latest
date from cells B4:H4 sheet 2 called 'Immunizations'? The information is in
the same workbook on another spreadsheet.

 

[Mike H]

Try

=MAX(Immunizations!B4:H4)

Format as a a date.

Mike

 

[Loadmaster]

Thank-you, I would not have figured it out that I actually wanted
=MIN('Immunizations'!B4:H4) had you not posted that response.