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
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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 2942 users have said thank you to us this month

So simple! And the perfect answer.
Many thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!