Require the heading date in which column found the first data/value in a specific row.

[ShaImran193]

Buyer	PO	Production Start Date	Day wise Production
9-Nov	10-Nov	11-Nov	12-Nov	13-Nov	14-Nov
CHS	100	9-Nov-24	3	5	5
KHG	101	11-Nov-24			4	2	5
Ikea	102	10-Nov-24		4	5	6	7
Simba	103	9-Nov-24	4	1

I need the above chart's production start date using an excel formula.
Please help in this regard.

 

[ShaImran193]

I need the above chart's production start date using an excel formula.
Please help in this regard.

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future, I suggest that you investigate XL2BB for providing sample data & expected results.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

See if this helps.

24 11 10.xlsm
	A	B	C	D	E	F	G	H	I
1	Buyer	PO	Production Start Date	Day wise Production
2				9-Nov	10-Nov	11-Nov	12-Nov	13-Nov	14-Nov
3	CHS	100	9-Nov-24	3	5	5
4	KHG	101	11-Nov-24			4	2	5
5	Ikea	102	10-Nov-24		4	5	6	7
6	Simba	103	9-Nov-24	4	1
Start

Cell Formulas
Range	Formula
C3:C6	C3	=MINIFS(D$2:I$2,D3:I3,"<>")

 

[ShaImran193]

Dear Peter_SSs,​

Your provided formula works fantastic.
It is really so helpful for me.
Thanks again for your help.
Thank you so much.

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.