I have created a number of automated reports in Excel and now need to pass
the actual report generation on to a team of Analysts.

There is a mix of automated and manual extracts that comprise the source for
these reports.

Is there a way I can test to see if the "Date Modified" for the source
file(s) is = to TODAY?

Thank you for your assistance!