looking for a date

  • Thread starter Thread starter Richdg
  • Start date Start date
R

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
 
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
 
Roger Govier said:
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
Click to expand...
 
Hi,

Since you are looking at dates

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

And then format the cell as needed.
 
Back
Top