It depends on how you want it to let you know.
For example you could add another column (if you make sure the analysis toolpak is loaded) which does this:
Then alongside each file which hasn't been updated for 6 months will have the warning alongside. If you want Excel to hunt these down and warn you you probably want some VBA/A Macro which is also possible.
Let us know exactly what you want it to do.