Creating a Word document from Excel data

[BrianHoard]

I'm sure this has been asked before, but I am not finding a solution searching this forum. I have been writing several Word VBA scripts in Word 2019, but this is the first time using Excel in a script. Here is my goal:


I make edits to the Excel file, and run the script. Not sure if it should be done from Excel or Word? I want to run some logic on the data to determine the number of days between todays date and the start date, which will be written in the Word document as Project Age.
I would like the script to loop through each row in Excel, and if the first column is "include", to include that row in the Word document, otherwise, skip that row. And format the text like the attached Word doc.
I'm also attaching a dummy Excel file for reference if anyone can get me started on the right track.