Comparing dates in multiple columns and using one that matches
Solved/Closed
Stovvy
Posts
1
Registration date
Friday October 7, 2016
Status
Member
Last seen
October 7, 2016
-
Oct 7, 2016 at 12:28 PM
Stovvy - Oct 7, 2016 at 01:16 PM
Stovvy - Oct 7, 2016 at 01:16 PM
Related:
- Comparing dates in multiple columns and using one that matches
- Display two columns in data validation list but return only one - Guide
- How to make multiple selections in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 7, 2016 at 12:53 PM
Oct 7, 2016 at 12:53 PM
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
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
Oct 7, 2016 at 01:16 PM
Many thanks