Transferring latest date from a row to another spreadsheet.
 

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.

Transferring latest date from a row to another spreadsheet.
 

Try

=MAX(Immunizations!B4:H4)

Format as a a date.

Mike

"Loadmaster" wrote:

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.

Transferring latest date from a row to another spreadsheet.
 

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

"Mike H" wrote:

Try

=MAX(Immunizations!B4:H4)

Format as a a date.

Mike

"Loadmaster" wrote:

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.