Excel date functions

Copper Contributor

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?

0 Replies