Hi Everyone,
How do I find the first and last Dates in a range of 12 columns? So that I can display the START date (first date found) and the FINISH date (last date found) per row? Please see attached screen snip.
First and Last Dates per row.jpg
Hi Everyone,
How do I find the first and last Dates in a range of 12 columns? So that I can display the START date (first date found) and the FINISH date (last date found) per row? Please see attached screen snip.
First and Last Dates per row.jpg
1. It is always best to attach a file and not a screen shot (see yellow banner at top of page)
2. When you say "First" and "Last" Dates Does first mean the first date it comes to or the earliest date (same thing for last).
3. Let's assume you want to see the Earliest and Latest Dates, you should be able to use the min and max formulas, like:
=MIN(A1:L1)
=MAX(A1:L1)
(A1:L1) is whatever the range of the columns you want to compare.
Hi Greg, understood about Point1. Point 2, earliest date and first date found will be the same thing, same for last date.
Thanks for the formulas, ill let you know how it works out.
Rod
Last edited by AliGW; 06-28-2020 at 12:18 AM. Reason: Please don’t quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks