Comparing dates in multiple columns and using one that matches [Solved/Closed]

Report
Posts
1
Registration date
Friday October 7, 2016
Status
Member
Last seen
October 7, 2016
-
 Stovvy -
Hello,

I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and dependent on this then check against the next column and so on for up to 5 dates. When it finds an answer to match it will calculate a difference in days. Please see example below

1 reply

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
Stovvy, Good afternoon.

Suppose:

A2 --> START DATE
G2 --> STOP DATE

H2 --> =(G2-MAX(A2:F2)) & " days"
Copy it down.

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3975 users have said thank you to us this month

So simple! And the perfect answer.
Many thanks