Oldest and Latest dates formula

[nagesh.tvsr]

Hi,

Need to get the Oldest an(Start date and End date) formula.

An excel file attached with necessary details.

Pl. help.

Thanks,
Nagesh.

[Bo_Ry]

Please try

=MINIFS($D$1:$O$1,D3:O3,">0")

and

=MAXIFS($D$1:$O$1,D3:O3,">0")
or
=LOOKUP(9^9,D3:O3,$D$1:$O$1)

[ardross]

Oldest:
=INDEX($D$1:$O$1,MATCH(TRUE,INDEX((D3:O3<>0),0),0))

Latest:=LOOKUP(2,1/(D3:03<>0),$D$1:$O$1)

[dosydos]

oldest

Please Login or Register  to view this content.

latest

Please Login or Register  to view this content.

[nagesh.tvsr]

Thanks Bo_Ry. Its working great.

[nagesh.tvsr]

Thanks ardross and dosydos too.