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

  • Thread starter Thread starter Jennifer eMe
  • Start date Start date
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?
 
Jennifer,

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

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

=min(rang)

Regards,
Fred.
 
Back
Top