Calculate to the latest date & ignore the previous

Hi All,

I am looking at the complex situation (for me . What i wish to achieve are the followings:
1. Cell B3 (Start Date) is the cell reference (DONE)
2. Cell C3:G3 with Start Date+365.25, this needs to be fixed for 12 months (DONE)
3. Cell H3 is where its uses the later date to calculate. for now im using =C3-TODAY(). Is there a way to automate by using Excel functions for H3 to be able to identify the later dates ie, in Cell C3:G3 & ignore the previous date? Otherwise, i need to manually move the formula from Cell H3 to the later date C3:G3

Please find attachment.

Thank-You very much.

Formula:

Please Login or Register  to view this content.

Hi AliGW,

Wow! That is magical!

Yes, it works like a charm...

Will mark this thread as Solved & added reputation to you

Thank-You very much

Hi Punnam,

Thanks for the solutions! Added reputation to you too...

Thank-You very much

Hi ,
Thanks & happy to help
Punnam