| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Picking a Date to Populate a Cell | Excel Discussion (Misc queries) | |||
| How do i remove the auto date function from a cell to allow # rang | Excel Discussion (Misc queries) | |||
| Populate a cell with a date using calendar pick | Excel Discussion (Misc queries) | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| Formatting a cell to populate on a certain date | Excel Worksheet Functions | |||
Hybrid Mode
