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

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?

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

Jennifer,

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

huber57

"Jennifer eMe" wrote:

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?

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

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

"Huber57" wrote:

Jennifer,

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

huber57

"Jennifer eMe" wrote:

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?

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

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

=min(rang)

Regards,
Fred.

"Jennifer eMe" <Jennifer wrote in message
...
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?