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

J

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?
 
H

Huber57

Jennifer,

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

huber57
 
F

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.
 
Top