+ Reply to Thread
Results 1 to 2 of 2

Formula to activate remaining days by start date, but driven by end date as well so target

  1. #1
    Registered User
    Join Date
    11-11-2019
    Location
    Oakland, CA
    MS-Off Ver
    365
    Posts
    1

    Formula to activate remaining days by start date, but driven by end date as well so target

    Hello,

    I created a formula on the Remaining work days that reflect start date and due date minus Sundays. My issue is that i want that remaining days number to start subtracting once the start date is equal to today(). Im looking for a formula that can help me drive remaining days by due date, but start subtracting once the start date meets =today()

    Under moment column, the start date is 11/8, but the remaining days is not subtracting. I attached an example of the formula in use. I need to find a way to tie in the =today() so the start date can make the remaining days start subtracting. The goal is the the daily targets are driven by due date so each station knows what to do daily. I can try attaching the actual schedule if needed.

    I appreciate any help with this manner!

    Thank you
    Attached Images Attached Images
    Last edited by ccosta86; 11-11-2019 at 11:49 AM.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Formula to activate remaining days by start date, but driven by end date as well so ta

    pls attach a file, not screenshot.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

+ 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. [SOLVED] Calculating Target Date/Time Based on Start date and hours - Excel 2007
    By chinraj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-09-2019, 01:43 AM
  2. Date Formula - Counting Based on Days Remaining the Week
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2019, 09:51 AM
  3. Replies: 7
    Last Post: 08-07-2018, 01:48 AM
  4. Replies: 1
    Last Post: 05-26-2014, 03:46 AM
  5. Replies: 2
    Last Post: 12-09-2013, 06:21 AM
  6. excel formula: days remaining=end date-todays date+extention days
    By fsprings in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-04-2013, 06:45 AM
  7. Replies: 3
    Last Post: 04-10-2009, 06:02 PM

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