pick first & last date as per the entries

[VICTOR5]

Hi folks,

I am trying to build a formula which will will be as below :

Pick the date from cell i2:bw2 to the cell d6 & e6 as per the first value and last value from the cell from i6:bw6.

in other ways I want to pick a date as of 1st and last of entry in the cell i6:bw6 to the cell d6 & e6.

for reference i attached the example sheet.

thanks...

[AliGW]

Start:

=INDEX(I2:BX2,,MATCH(TRUE,INDEX(ISNUMBER(I6:BX6),0),0))

End:

=LOOKUP(2,1/(I6:BX6<>0),I2:BX2)

[VICTOR5]

Thank You AliGW

[AliGW]

Glad to have helped.

If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.