| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Earliest Date to populate?
Anyone,
I'm trying to gather a bunch of dates in an Excel spreadsheet row and have the earlies date by itself just populate in a cell. Does anyone have a sample formula to use? It's racking my brain and driving me nuts! Thanks! |
|
#2
|
|||
|
|||
|
=MIN(A1:Z1)
Biff "sonquizzon" wrote in message ... Anyone, I'm trying to gather a bunch of dates in an Excel spreadsheet row and have the earlies date by itself just populate in a cell. Does anyone have a sample formula to use? It's racking my brain and driving me nuts! Thanks! |
|
#3
|
|||
|
|||
|
Have you tried:
=MIN(A1:A10) Just replace A1:A10 with your actual range of dates. You might have to format the result as a date (otherwise you'll get a number in the 38 thousand range) Does that help? -- Regards, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Automatic Populate Todays Date in Cell when File is Saved. | Excel Discussion (Misc queries) | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| date and time | New Users to Excel | |||
| Formatting a cell to populate on a certain date | Excel Worksheet Functions | |||
Linear Mode
