+ Reply to Thread
Results 1 to 4 of 4

Formula for calculate date after adding 90 days to it

  1. #1
    Registered User
    Join Date
    03-11-2005
    Posts
    2

    Question Formula for calculate date after adding 90 days to it

    What formula can I use to calculate a Date2 based on another Date1. For instance Date1 would be the commencement date, and Date2 will be a Disbursment date. Date2 needs to be calculated based on Date1 + 90 days.

    For example, if DATE1 ( Commencement Date) = Sept 1/05 and it is a seven month program, then DATE2 should be 1st day of 4th month, i.e. Dec 1/05

    if nine month program, then DATE2 will be made on 1st day of fifth month, i.e. Jan 1/06

    Any help in this regard much appreciated.

    thanks,

  2. #2
    Registered User
    Join Date
    09-10-2003
    Location
    Detroit, MI
    Posts
    59
    Check Chip Pearson's site and look under "D" for "Date Arithmetic":

    Chip Pearson's Site Contents
    Neopolitan (Florida Dreaming)

  3. #3
    Registered User
    Join Date
    03-11-2005
    Posts
    2
    Thank you that was an awesome pointer.
    -aman

  4. #4
    Registered User
    Join Date
    09-10-2003
    Location
    Detroit, MI
    Posts
    59
    My pleasure.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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