+ Reply to Thread
Results 1 to 3 of 3

Date calculation based on several dates

  1. #1
    Forum Contributor
    Join Date
    11-03-2004
    Posts
    139

    Date calculation based on several dates

    I would greatly appreciate any help with this calculation. In column e I have a program start date. In column f is a graduation date, in column g is the date for leaving program and in column h is a termination date. In column i is the formula dateif for months and column j is the formula dateif for the days formula. These caluculate for the program start date and the graduation date. But I would like them (i and j)to calculate from the program start date and then whatever column has the next date, whether it be f, g or h.
    Thanks
    Michelle

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,721
    perhaps, for I2

    =DATEDIF(E2,IF(ISNUMBER(F2),F2,IF(ISNUMBER(G2),G2,H2)),"m")

    and similar in I2 for days

  3. #3
    Registered User
    Join Date
    12-28-2006
    Posts
    5
    Perfect - Thank you so much.
    Michelle

+ 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