Hi,
I am not familiar with macro nor VB but I know this can be done somehow. I want to have an email send to a specific email address 2 or 8 months prior to the expiry date (In the email, I like to have it state the unit name as well). The "Expiry Date" column contains multiple dates for a specific group. I only want the last date in each group to have an email send 8 months prior to the expiration while the others to be 2 months. Attached is the template for it.
I already set a conditioning format to those cell with this: AND(MONTH($G$26)-MONTH(TODAY())<=8,TODAY()-$G$26<=0,YEAR($G$26)=YEAR(TODAY()) and with the "next month" default conditioning format on the other cells.
Any kind of clue on how to do this is appreciated. Thanks!testdates.xls
Bookmarks