Formula to Pick Start Date

[rizmomin]

Hello:

Please refer to attached excel file and go to Summary Sheet.

I need a formula in cell c1 so that it gets the closest start date for this week from data in column J.
Manually right now i would choose 10/31/2014 as start date.

Please refer to attached file.
Let me know if you have any questions.
Thanks.

Riz

[Punnam]

Hi,

Check the updated sheet with the help of helper column

Please Login or Register  to view this content.

in C1

Please Login or Register  to view this content.

in d1

Punnam

[Crooza]

This might be simpler in C1

=TODAY()-WEEKDAY(TODAY())-1

It will give you the most recent historic date in your list

[boopathiraja]

Hi, apply this array formula in c1 ,

Please Login or Register  to view this content.

[rizmomin]

Hi Crooza:

Your formula works great.
Thanks a lot...
Riz

[rizmomin]

Hi Crooza:

Your formula works great.
Thanks a lot...
Riz

[Crooza]

Great. Glad it worked