Looping Macro

Hello all,

Need a little help writing a macro that will run through a report and change the following:

If Col D = “Open”, then change to “

If Col D = “Open”, then Col E changes to “Y”, Col F changes to “Y” and Col G changes to “N.”

Please see attached workbook DatesReport for before and after versions. Would need this to loop through over 3K rows.

Thanks for any and all help!