Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    53

    Unanswered: Combine number of months and days to determine new date

    Hello All!

    Am trying to consolidate all these formulas into one. Please see below:

    First formula determines an effective date based on a 1/1/2015 hire date with a 6 month waiting period

    Code:
    DATE(YEAR(A1),MONTH(A1)+B8,DAY(A1))
    =12/1/2014

    From here I need to determine the last day in the month from the formula above

    Code:
    EOMONTH(C8,0)
    =12/31/2014

    Based on the date generated above, need to add an addtional 30 days waiting period

    Code:
    EOMONTH(A11+29,0)+1
    =2/1/2015

    Any suggestions greatly appreciated it!

  2. #2
    Join Date
    Jan 2013
    Posts
    53
    If anyone can suggest a vba function that would be helpful as well.

Posting Permissions

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