Greetings! I have a spreadsheet which lists contract Effective Dates in column A, and contract Expiration Dates in column B. Column E lists dates (E1=1/1/2019, E2= 2/1/2019, and so on...)
I'm needing to create a chart so I can see a visual of how many ACTIVE contracts per month that we'll have over the next several years. Can anyone assist with the formula I'd put into F1?
Thank'ya in advance!!
I'm needing to create a chart so I can see a visual of how many ACTIVE contracts per month that we'll have over the next several years. Can anyone assist with the formula I'd put into F1?
Thank'ya in advance!!