Change from "Week Ending" date to real date

[my8950]

We get these spreadsheets from a customer, they are stuck using week ending and will not change to the actual date.
What I am thinking to do is, or what I would like to do is, add a column, and then I would like to have it show me the actual date in that column that the entry is made.

If you see below, the snapshot of the spreadsheet.
Column D has the week ending date.
J,K,L,M,N,O,P are days.
There will only be one hour entry for each line, so if I were to add a column that would be column I.
I would like it to search the date where the hour is not equal to 0, and put the date in column I.
I'd need it to do this for each line.

Hopefully this makes sense, looking for ideas/suggestions/better ways/anything on how to go about doing.

Thank you!

 

[AhoyNC]

Maybe:

Book1
	D					I	J	K	L	M	N	O	P
1	Week End					Date	Sat	Sun	Mon	Tue	Wed	Thu	Fri
2	4/24/2020
3	4/24/2020
4	4/24/2020					4/22/2020	0	0	0	0	2	0	0
5	4/24/2020					4/22/2020	0	0	0	0	1	0	0
6	4/24/2020					4/20/2020	0	0	1	0	0	0	0
7	4/24/2020					4/21/2020	0	0	0	0.5	0	0	0
8	4/24/2020					4/21/2020				0.5
Sheet1

Cell Formulas
Range	Formula
I2:I8	I2	=IFERROR(D2-(7-MATCH(MAX(J2:P2),J2:P2,0)),"")

 

[my8950]

Maybe:

Hello, Thank you for your reply!
From what I can see, you are putting this formula =IFERROR(D2-(7-MATCH(MAX(J2:P2),J2:P2,0)),"") into I2?
The example you posted looks right, and what I would like mine to do, but when I put that formula into I2, it just says 0.
I'll keep messing with it and see if I can find what the issue is. This is fairly new to me, using a formula more complicated that add or subtract.
Thanks!

 

[my8950]

Aha, simple cell placement error.
This is perfect, thanks again for your help!!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.