I'm attempting to make a calendar for auditing purposes. My goal is to input all data on one page, then have a list of upcoming audits on a different page
So on the data page, I have:
Company | Enroll Date | 90Day | Anniversary | Officer
ABC Corp | 1/2/18 | 4/1/18 | 1/2/19 | Hopbow
LOP Corp | 10/1/18 | 1/1/18 | 10/1/19 | Hopbow
XYZ Corp | 4/1/18 | 7/1/18 | 4/1/19 | Hopbow
On the Audit Page, I would like to show the company name, date of audit, and the loan officer
Company | Audit Date | Officer
ABC Corp | 1/2/19 | Hopbow
LOP Corp | 1/1/19 | Hopbow
I've currently got 3 named ranges - 1 is all data, 2 is all 90Day data, 3 is all Anniversary data (though 2&3 should probably be the same range)
For testing, I've been trying to get any information at all from the 90Day range, so my current formula is {=Match(_90Day<=EDate(*cell ref that =today()*,1),_Day90,0)}
Does anybody have any thoughts at all on this?
