Hi guys,

I'm in need of some assistance that I've usually always found helpful on here..

Essentially what I'm doing is a matrix of meeting dates with a number of attendees and the topic etc.


Currently as it stands the worksheet looks like:

Attendees Email Send Reminder Topic 1 Topic 2 Topic 3
Bob Bob@sample.com YES 16/04/2014 17/05/2014


Under 'Send Reminder' the formula so far is (=IF(NOW()>G11-7, "YES", "NO") which as it stands needs tweaking which I need help with so that it looks at the entire row to check all dates with regards to the current date.

What I want to happen with the code is for it to check the worksheet and if a meeting is coming up in a week - for it to send an email reminder to the person for which the meeting requires their attendance.

I may not be going about this the right way with the 'Send Reminder' column but would appreciate some inputs!

As always, really appreciate the support on this forum.

Kind regards,
MW