Results 1 to 4 of 4

Projected date formula from a combination of a 2 cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-28-2004
    Location
    Tokyo
    MS-Off Ver
    Office 2016 pro plus
    Posts
    175

    Projected date formula from a combination of a 2 cells

    I am trying to make the "Next Phase up DATE" cell automatically configure accorfing to the Issue date and the PHASE 1, PHASE 2, PHASE 3 Selection.

    Phase 1 last for 14 days
    Phase 2 last for 21 days
    Phase 3 has no phase up date

    So if I put 1 July 09 in Issued Date cell and select Phase 1, the "Next phase up date will be 15 July 2009

    If 1 July 09 in Issued Date cell and select Phase 2, the "Next Phase up date will be 22 jul 09

    If 1 July 09 in Issued Date cell and select Phase 3, the "Next Phase up date
    cell will be (N/A or something to that nature.)

    The Doortag portions are refrenced to the upper portions, so I only need the formula for (merged)CDE10 & (merged)CDE32
    Attached Files Attached Files
    Last edited by skylinekiller; 08-03-2009 at 11:16 AM.

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