Date Fill formula

Good afternoon help.

I require help with the attached please.

Excel version is Microsoft 365 subscription.

Can somebody write me a formula that populates the date (1st of the month), in columns J & K, where the start date is the first time a 1.0 appears in the respective row and the end date is the last time a 1.0 is inserted. hope that makes sense.

Start date then populates in Column J

End Date populates in Column K

Dave

Start Date: =INDEX($L$1:$AX$1,MATCH(1,$L2:$AX2,0))

End Date: =LOOKUP(2,1/($L2:$AX2<>0),$L$1:$AX$1)

If you want the end of the month, change the second formula to this:

=EOMONTH(LOOKUP(2,1/($L2:$AX2<>0),$L$1:$AX$1),0)

Glad to have helped.

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue 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.