Previous Topic Next Topic

Dates

Solved/Closed
Fred - Mar 4, 2010 at 09:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 10:59 AM
Hello,
Crazy question....
I have a row full of different dates. I would like to create a formula to display in a separate cell, the earliest date from that row. Is there a way to do this?

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 4, 2010 at 09:55 AM
Could you explain with example
0
Fred
Mar 4, 2010 at 10:02 AM
I have a spreadsheet with on column showing several rows of dates.
I want to have a separate cell that will automatically show the earliest date from that selected row.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Fred
Mar 4, 2010 at 10:05 AM
You can use min function

this give minimum date in range a1 to a10
=min(A1:a10)
0
Fred > rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Mar 4, 2010 at 10:16 AM
WOW, that was so simple I feel stupid.
Thanks
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Fred
Mar 4, 2010 at 10:59 AM
Nothing is simple. It took me a considerable time to finally realized, my keyboard does not have an "any" key and that pressing space bar works just as fine as pressing that elusive "any" key
0

Similar discussions

Excel VBA Code Date Filter between two dates
Bhaskar -
Basit -

1 response
If a cell contains any text then add a value (with dates)
ryannordgren -
ryannordgren -

7 responses