Add date + 3 months in vba so the VBA sends mail reminder exactly 3 months before due date

[JimmyQ]

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:

Please Login or Register  to view this content.

[Bob Phillips]

You could try this

Please Login or Register  to view this content.

although this also has problems, if today is 30th November 2013, it will project forward to the 2nd March 2014.

[ragulduy]

Please Login or Register  to view this content.

Will give you the datevalue (e.g. 45536) for 3 months from todays date.

[JimmyQ]

yeah that will only happen if i run the macro on the wrong day if i lock it to only start it on the first, for example 1 November 2013 then he will check if any date expires 1 march 2014.

if that is the case then it solved