IF/AND statement to count date ranges?

I'm admittedly an Excel amateur and am looking for some help to classify date ranges in the attached book.

Columns E:G are meant to indicate whether or not the names in column A have volunteered over 1 months (30 days), 3 months (90 days), or 6 months (180 days).

For example:

James Brown's first/last dates are 4/1/17 & 5/31/17. 'yes' in 1 month (because over 30 days) but 'ignore' in 3months, 3 months columns because those dates are in the future and haven't occurred yet. This is important that it isn't classified as "no" because they are still actively volunteering in the future

Jane Black's first/last is 5/1 and 5/10. She did not even meet 1 month, so all values for her are "no"

Is there a way to automate the cells in E:G based on the time periods in the B, C, and D columns?