Find the latest occurrence of date in the row

[goodboy]

Hi,

I want to find the latest occurrence of date in the row. I have posted a sample file please help.

Regards
Goodboy

[Pete_UK]

Put this array* formula in P3:

=IFERROR(INDEX(A3:O3,MAX(IF((B3:O3>0)*(MOD(COLUMN(B:O),2)=0),COLUMN(B:O)))),"")

then copy down.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual < Enter >.

Hope this helps.

Pete

[goodboy]

Thanks Pete it work with the given set up but my query is if i insert any date the answer doesn't change example if i put 6/10/2016 in cell 03 it does not give me the result of cell O3 can u please explain or any formula with which it can be done.

[Pete_UK]

Your dates seemed to be in alternate columns (B, D, F etc.) so the formula only looks at those columns - put the date in N3 and you will see it change.

Hope this helps.

Pete

[sandy666]

All dates are from 2016 or what is a range of the years?

btw. formula #2 has a defect in the case if you insert value equal to the datevalue the result will be incorrect. E.g. 42500 with format different than date.