Hi,
I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s.
Zero values in between positive #s count.
Zero values do not count before the first positive # or after the last positive #.
I appreciate your time.
I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s.
Zero values in between positive #s count.
Zero values do not count before the first positive # or after the last positive #.
Client | 5/31/2022 | 4/30/2022 | 3/31/2022 | 2/28/2022 | 1/31/2022 | 12/31/2021 | 11/30/2021 | 10/31/2021 | Formula Answer | |
A | 0 | 1 | 2 | 1 | 4 | 0 | 4 | |||
B | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 5 | ||
C | 0 | 6 | 1 | 0 | 0 | 0 | 0 | 2 | 7 |
Mr Excel
lookup range of dates 2.00%,6/1/2020,3/31/2022,date,int rate,<a href="https://www.mrexcel.com/board/threads/lookup-return-from-range-of-dates.1256634/#post-6171377">https://www.mrexcel.com/board/threads/lookup-return-from-range-of-dates.1256634/#post-6171377</a> 3.00%,4/1/2022,6/30/2023,Jul-20,2...
docs.google.com
I appreciate your time.
Last edited by a moderator: