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?

Dates
Apple iphone 13 release dates - Guide
Vivatech 2024 dates - Guide
Annual mileage calculator with odometer dates ✓ - Excel Forum
Defcon dates - Guide
Different dates of "end to end encryption message" on blank chat? - Download - Encryption and decryption

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

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.

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)

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

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

Similar discussions

encryption message several time in chat

IF statements with dates and criteria

blank white page for website

using web browser page loads but screen blank

using nested if to blank out adjacent cells

Similar discussions

Subscribe To Our Newsletter!