looking for a date
 

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

looking for a date
 

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

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

looking for a date
 

Your subject line indicates that you want E-Harmony.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

looking for a date
 

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