Inverse: INDEX-MATCH-MATCH

[jbeam4me]

See picture/link below (this is a daily account gantt forecasting chart).

OVERVIEW

1. ROLLING DATES: each day of 12-months listed in its own column:
   1. From 1/1/17 thru 12/31/17 (only 1/19/17 thru 3/6/17 is pictured).
   2. Row 1: Lists the month in custom date format (i.e., January 2017, February 2017...)
   3. Row 2: Lists the day of the month above in custom date format (i.e., 1, 2, 3...)
   4. Conditional Formatting (AD2:AD13): simply adds colored border for "TODAY()".
2. CUST/RIG: each customer has specific ongoing accounts, each with its own specific start/end dates.
   1. Before the customer "officially" calls us out to a job (ACCT1, ACCT2,...), I forecast an approximate start date, indicated with a yellow "!" symbol to represent potential revenue, but not guaranteed.
   2. Once we are officially on location, generating revenue, I copy/paste a green block (with a green "x" that makes it "invisible and just appears as a green-colored box).
   3. Once we finish a job, no longer generating revenue, I copy/paste a blank white box.
3. "RIG DAYS" Actual & LTF columns:
   1. These columns simply SUM all "x" & "!" occurrences for each ACCT.
   2. The same SUM formula occurs in rows 14 & 15 to sum totals for each day.

HERE'S WHAT I WOULD LIKE A NON-VBA FORMULA TO OUTPUT:
On a separate worksheet, with the same A & B columns, I am adding a C column that I want to display current ACCT status. I don't care about "x" & "!" occurring in the past--only current day & future forecast:

1. First (easier) example - CUST1/ACCT2 (Row Row 4): will output "NOW-02/18"
   1. Because today (01/26) has a green "x" and each day after thru 2/18 (2/19 status changes to a "!").
2. Second (moderate) example - DVN/ACCT1 (Row 7): will output "02/04-02/09":
   1. Because today (01/26) is blank & the next "x" occurs on 02/04 which continues daily thru 02/09 (02/10 status changes to a "!").

I've tried the INDEX-MATCH-MATCH but, at least in my understanding of the formula, it works very well in using column/row headers to extract the instersecting value from the table; but what I'm needing is a formula that returns the date at which a green "x" starts and the date it ends relative to TODAY().

PICTURE LINK HERE

Many thanks in advance!