Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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).

image text in transcribed

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 20

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions