How to enter date associated with last number greater than zero or last zero in row

I am trying to determine when a product ends by evaluating either the last number in a row that is greater than zero or finding the last zero in a row.

I've tried a formula using MAX in A7 and another using INDEX/Match in A8. The MAX formula returns a date really off base and the INDEX/MATCH formula returns the first date that has a zero, not the last date.

Cells B7 equal what the date should be if using the last zero and cell C7 is the date with the last volume. Either solution or both would be great.

Thank you very much in advance for any support.

Hi, I have questions:
- "either the last number in a row that is greater than zero or finding the last zero in a row" - this would imply you're looking for the last number in a row only? e.g. whatever the last number is, 10000 or 0, it would always fulfill your criteria?
- your desired data in columns B and C make no sense to me: e.g. in row 15: you say volume ends Feb-2020 but the last value is actually Jan-2022?
- Your column headers are no dates but text strings for month and year only, so how does your desired output get to specific days?

Can you clarifiy if the following is what you're trying to do: When the total of a year is >0, you want the month (and year) of the last non-zero value? (e.g. the last non-zero month ignoring year totals)

I also believe your task is complicated by the fact that:
- you have row totals within your actual monthly data rather than at its end
- your column headers are text strings rather than actual dates

But put in this formula for row 7 (may have to be entered with ctrl+shift+enter) and see if it does what you're looking for:
=LOOKUP(2,1/((RIGHT(H6:AT6,4)*(LEN(H6:AT6)>4)=LOOKUP(2,1/(ISNUMBER($H$6:$AT$6)*(H7:AT7>0)),$H$6:$AT$6))*(H7:AT7>0)),H$6:AT$6)

Regards

@bebo021999, you may want to check the workbook you attached, seems like something else?

Regards

@bebo021999, thank you for the support. Your formulas worked well and solved my issue. I especially liked the formula used in E6.

@RaulSerg, thank you also for the feedback. I could not get your formula to work in A7 using as an array or just entering. The result was #N/A each time.
For your questions:
-"either the last number..." I was looking for a formula that would tell me what date the last volume was entered. the volume (or number) would have to be greater than zero. My issue was there are months when there are no orders but future orders still are placed. My original formula would stop at the first instance of no order. The formula bebo021999 used in B7 worked for this issue.
-"your desired data...row15..." Feb 2020 was a typo, apologies, I meant for it to be Feb 2022 to show this was the last zero after a cell with a value greater than zero.
- "Your column headers are text..." Agreed and corrected using bebo021999 formula.

Thank you both again for the feedback and efforts.