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
 
It may be America where you are but it certainly isn't everywhere else!
 
Assuming "soonest date in a rang" is the earliest date, you get this with
the Min function, as in:

=min(rang)

Regards,
Fred.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Average dates help 0
import excel 2003 dates & notes to Julian calendar format? 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting cells in a selectable date range 0
Excel 2003 make 1 date cell automatically change another date cell 3
Formatting Date Cell with No Values 2
Adding days to a date - changed in Excel 2010 8

Back
Top