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

**EmDubeu** · 08-19-2016, 03:27 PM

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

**Green Crocodile** · 08-19-2016, 04:05 PM

When you say number of days what do you mean? Are you referring to days between or how many cells have dates entered in column B. Can you please explain how on your example you provided you came up with the answer 7 for the days?

**JieJenn** · 08-19-2016, 04:09 PM

=max(a2:a9)-min(a2:a9)+1

**EmDubeu** · 08-19-2016, 04:11 PM

Originally Posted by Green Crocodile

When you say number of days what do you mean? Are you referring to days between or how many cells have dates entered in column B. Can you please explain how on your example you provided you came up with the answer 7 for the days?

Good question; sorry about the vagueness. "Number of Days" is the count of dates in the cells for column A. The count of "7" in B2 is the number of unique days found in column A.

Does that clarify or make it worse.

**EmDubeu** · 08-19-2016, 04:14 PM

Originally Posted by JieJenn

=max(a2:a9)-min(a2:a9)+1

I modified your formula a bit to account for the fact that the formula won't know where the end date is. =max(a2:a)-min(a2:a)+1

I think that works.... checking.....

**JeteMc** · 08-19-2016, 04:33 PM

Welcome to excel forum.
You may also want to try this: If I understand correctly the next date stamp will be placed in A1 and the 8/13/2016 date stamp will move down to A10. Also I assume from the picture that the count of days will be held in B1 when the new date stamp is added. Given that paste the following formula in B1:

Formula:

Please Login or Register  to view this content.

Let me know if you have any questions.

**EmDubeu** · 08-19-2016, 04:34 PM

Mark this thread solved! Thanks for the quick help!

**JeteMc** · 08-19-2016, 04:41 PM

You're Welcome and thank you for the feedback. To mark the thread 'Solved' use the thread tools link above your first post. I hope that you have a blessed day.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] COUNTIF? (Count number of date values in a column more than 30 days old)

Calculate Number of days from date registered column A and Todays date Column B

Count number of consecutive days by date

Need to count number of days from a given date in a cell from the current day

[SOLVED] How to accurately/precisely count number of months, days from a particular date to a date

Count the number of days from the date of report upto the date it was closed

[SOLVED] How do I count the number of days from 1 date to another?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions