Looking for a solution that returns a date based on a "least of" two criteria.
One based on Tenure & the other based on Age
Please find enclosed a sample excel sheet
Thanks in advance
Looking for a solution that returns a date based on a "least of" two criteria.
One based on Tenure & the other based on Age
Please find enclosed a sample excel sheet
Thanks in advance
The following agrees with your expected results give or take a day at most. Is that good enough ?
In H13 copied down to H21:
Formula:Please Login or Register to view this content.
Let me know if this works for you.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
This has been posted on at least THREE other forums!!!
Solved on Chandoo.
Last edited by AliGW; 06-02-2019 at 01:15 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
FYI multiple and repetitive cross poster
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks