Question
Need to write a formula in cell G6 that tells me the month with the first number greater than zero. In this case, cell G6
Need to write a formula in cell G6 that tells me the month with the first number greater than zero. In this case, cell G6 should return 10/1/17
In cell G7, I need formula that tells me the latest date. In this case, cell G7 should return 9/1/18
In cell G8, I need formula that tells me that number of months between cells G6 and G7. In this case, cell G8 should return 11
Here is how the input should look (Please note that the formula used needs to work even in the scenario where the first number greater than could be in the first month, last month, and/or somewhere in between).
6/1/2017 7/1/2017 8/1/2017 9/1/2017 10/1/2017 16,577 11/1/201751,370 12/1/2017101,330 1/1/2018 113,153 2/1/201823,295 3/1/2018 136,538 4/1/2018 92,676 /1/2018172,871 6/1/2018 196,096 7/1/2018129,883 /1/2018 154,008 9/1/2018 104,046 4 10 12 13 14 15 16 18 19 20Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started