Hi,

Since you are looking at dates

=LOOKUP(9^5,Sheet1!$1:$1)

And then format the cell as needed.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Richdg" wrote:

i need a formula to display a date from a row of cells on a seperate page. it
needs to ignor all other dates except the last one in the row

id appreciate help