Dates

Solved/Closed

Fred - 4 Mar 2010 à 09:49
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Mar 2010 à 10:59

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

Réponse 1 / 1

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Mar 2010 à 09:55

Could you explain with example

Fred
4 Mar 2010 à 10:02

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 28 January 2010 Status Contributor Last seen 5 May 2022 766 > Fred
4 Mar 2010 à 10:05

You can use min function

this give minimum date in range a1 to a10
=min(A1:a10)

Fred > rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022
4 Mar 2010 à 10:16

WOW, that was so simple I feel stupid.
Thanks

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766 > Fred
4 Mar 2010 à 10:59

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

Whatsapp web "chat to myself" not working

Conditional Formatting - highlight overdue dates

Using IF function with dates

Similar discussions

Subscribe To Our Newsletter!