looking for a date

[Richdg]

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

 

[Roger Govier]

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

 

[Richdg]

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



thanks works perfectly

 

[Don Guillett]

Your subject line indicates that you want E-Harmony.

 

[Shane Devenshire]

Hi,

Since you are looking at dates

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

And then format the cell as needed.