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 by 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

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
Leave a 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!