In my sheet i have number of different dates. I have now a vba macro that tells excel to check my list for expired dates and then sending it to different emails with a encouragement to act to the information in the mail
what i WANT it to do is to check the list and see if any dates expires exactly 3 months from the date given in the sheet
i have already tried to (date + 90) the problem with that is february is 28 days and then the whole thing falls apart and i need the vba to be flexible to expand the workarea.
this sheet is going to be scheduled on to run first day of the month around the year. Every date in the sheet are preset to be the first day of the month.
this is how it looks now:
Bookmarks