Report

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

Ask a question Stovvy 1Posts Friday October 7, 2016Registration date October 7, 2016 Last seen - Last answered on Oct 7, 2016 01:16PM
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

See more 
Helpful
+1
moins plus
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
Stovvy- Oct 7, 2016 01:16PM
So simple! And the perfect answer.
Many thanks
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!