Error image after using Byrow function

I would like to get the start and end dates based on the row data information, which is their attendance on daily basis. Is there any formula which could really help?

CodePudding user response：

For Start Date:

=BYROW(F2:S6,LAMBDA(ζ,XLOOKUP(1,0/ζ,F1:S1,,-1,1)))

Same for End Date, though changing the last parameter from 1 to -1.