Find a date same row in multiple coulmns

[lbrut]

Thought I was a reasonable user but have read lots of posts but cant work out this one which I am guessing is going to be embarrassingly simple.

Could someone please advise how to search along same row but over multiple columns to find a date. There will only ever be one date across the columns - the rest of the cells will have the word "false" in them.

need search result copied here false false false 01/01/2016 false false

Many thanks - Roger

 

[zulfikarzulu]

Assuming you paste the the formula in Cell A1 and your Data starts from B1 to Z1 you may paste the below formula in Cell A1:

Note: The below formula will work in Excel 2010 or later

=INDEX(B1:AZ1,AGGREGATE(14,6,--ISNUMBER(B1:AZ1)*(COLUMN(B1:AZ1)-COLUMN(A1)),1))

For Previous versions use this formula

=INDEX(B1:AZ1,LARGE(--ISNUMBER(B1:AZ1)*(COLUMN(B1:AZ1)-COLUMN(A1)),1))

and also you need to use Ctrl + shift + Enter for the second formula only enter won't do the trick

 

[Shweta]

You can try this one as well.

=INDEX($B$1:$AZ$1,MATCH(1,ISNUMBER(B1:AZ1)*1,0))

with Ctrl+Shft+Enter

 

[lbrut]

Thought I was a reasonable user but have read lots of posts but cant work out this one which I am guessing is going to be embarrassingly simple.

Could someone please advise how to search along same row but over multiple columns to find a date. There will only ever be one date across the columns - the rest of the cells will have the word "false" in them.

need search result copied here false false false 01/01/2016 false false

Many thanks - Roger

Many thanks to all - speedy response very much appreciated - perfect - will now teach myself how each formula works
Roger