Can I get Excel to populate a cell with the soonest date in a rang

[Jennifer eMe]

I am managing a few projects to completion in Excel. I have dates by when
tasks need to be accomplished, and each worksheet has a Next Action date
field that I want Excel to update automatically. Is this possible?

 

[Huber57]

Jennifer,

This is America. Anything is possible! Can you give me some specifics of
what you want done?

huber57

 

[Mike H]

It may be America where you are but it certainly isn't everywhere else!

 

[Fred Smith]

Assuming "soonest date in a rang" is the earliest date, you get this with
the Min function, as in:

=min(rang)

Regards,
Fred.