Replace Data depending on file date

[MHamid]

Hello,

Is it possible to create a vba code that will replace data in some columns depending on the date in the file name?

For instance, I have a file name "YYYY_AA_BCDE_YYYY_MM_DD_v#.#_(Mar_Final)".In the first sheet, I have a date in column O. If the file name is (Mar_Final), then if the date in column O is after March, replace that date with N/A and go to column M of the same row and replace any data in that row to N/A.
Original Data:
Column M Column O
Dummy Data 04/04/2018
If File name is Mar_Final
Column M Column O
N/A N/A

The second sheet within the same file has a date in column D. If the date, is after the date in the file name (Mar_Final), then I need the word "Completed" in column C to be changed to "In Progress" and I need any data in columns D, E, F to be cleared within the same row.

Is it possible to do this with VBA code? I'm looking for two different VBA codes for each circumstance.

Thank you