+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007, 2013
    Posts
    14

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

    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.
    Last edited by JimmyQ; 01-03-2014 at 08:43 AM.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,282

    Re: Add date 3 months in vba so the VBA sends mail reminder exactly 3 months before due da

    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.

  3. #3
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

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

    Please Login or Register  to view this content.
    Will give you the datevalue (e.g. 45536) for 3 months from todays date.

  4. #4
    Registered User
    Join Date
    12-16-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007, 2013
    Posts
    14

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

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-26-2013, 09:48 AM
  2. Dynamically Filling in Allocation in Months based only on Start Date and End Date
    By Computermoss in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-07-2013, 01:16 PM
  3. [SOLVED] Display cells 12 months prior and 12 months post from a given date
    By hog77 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2012, 06:25 AM
  4. Replies: 2
    Last Post: 01-04-2012, 09:15 AM
  5. Replies: 2
    Last Post: 12-09-2011, 08:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1