looking for a date
"Roger Govier" wrote:
Hi Rich
With your dates in Sheet1 row 1
=TEXT(LOOKUP(9^99,Sheet1!$1:$1),"dd mmm yyyy")
Change the Sheet location and row to suit, and choose whatever date format
you want between the quotes
--
Regards
Roger Govier
"Richdg" wrote in message
...
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
thanks works perfectly
|