Results 1 to 8 of 8

Count number of days in column without an end date?????????

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2016
    Location
    USA
    MS-Off Ver
    2010
    Posts
    4

    Count number of days in column without an end date?????????

    I need a formula that counts the number of days in an entire column where I only know the start date and not the end date (A2:A for example). I have script that inserts a date stamp when an event occurs and this date stamp goes into column A with the most recent on top. The end date is never known, however I need to count the number of days that are currently in the column without knowing the end date. How can I accomplish this?

    For example:

    A B
    1 DATE STAMP NUMBER OF DAYS
    2 8/19/2016 7
    3 8/18/2016
    4 8/17/2016
    5 8/16/2016
    6 8/15/2016
    7 8/14/2016
    8 8/13/2016
    9 8/13/2016
    10 cell is blank
    11 cell is blank
    12 cell is blank
    13 cell is blank
    14 cell is blank
    15 cell is blank
    Last edited by EmDubeu; 08-19-2016 at 04:05 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 01-03-2021, 06:24 PM
  2. Replies: 3
    Last Post: 04-08-2016, 09:11 AM
  3. Count number of consecutive days by date
    By malek_ali7sas in forum Excel General
    Replies: 11
    Last Post: 02-21-2016, 10:17 AM
  4. Replies: 6
    Last Post: 08-27-2015, 06:40 PM
  5. Replies: 5
    Last Post: 07-25-2015, 11:39 AM
  6. Replies: 4
    Last Post: 04-24-2014, 04:34 AM
  7. [SOLVED] How do I count the number of days from 1 date to another?
    By Steve R in forum Excel General
    Replies: 3
    Last Post: 02-02-2006, 05:00 PM

Tags for this Thread

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