+ Reply to Thread
Results 1 to 2 of 2

Formula that counts cumulative days when one value is missing.

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Mineola, Texas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Formula that counts cumulative days when one value is missing.

    In excel 2007:

    Column E is formatted as date and is the start date.
    Column F is formatted as date and is the end date.
    Column G is formatted as number and is the cumulative number of days between E and F.
    Problem: What is the formula to show the number of days that have passed in G when a date is entered in E, F is blank and will only stop counting when a date is entered in F.
    Example: The current date is 11/21/12. E is 11/01/12, F is blank, and G shows 21.
    Last edited by me1me2; 11-21-2012 at 01:57 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula that counts cumulative days when one value is missing.

    With
    E1: a date....01-Nov-2012
    F1: a date (or blank)

    this regular formula returns the number of days between F1 and E1...Using today's date if F1 is blank:
    G1: =IF(F1="",TODAY(),F1)-E1

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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