Is there a way to put a date row into a single cell on another sheet with the most current date?

Paisdais

I am trying to have a sheet that reports multiple sheets. I have merged cells and that works but I am looking to merge a whole row of dates to a single cell with the most current date featured.

KPH

Hi

I'm not sure what you mean by merge. Do you have a sheet with dates in lots of columns and you want to return the latest date? Like this?

If so, you can use a MAX function:

=MAX([Date 1]@row:[Date 4]@row)

KPH

Hi

I'm not sure what you mean by merge. Do you have a sheet with dates in lots of columns and you want to return the latest date? Like this?

If so, you can use a MAX function:

=MAX([Date 1]@row:[Date 4]@row)