I've spent way too much time trying to figure this formula out. I need help.
I have a named range "rng_ReportPeriod" that I manually assign a value to on a monthly basis, and it is ALWAYS the last day of the current month.
Thus, currently rng_ReportPeriod is 3-31-18
Elsewhere in my spreadsheet...