Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 7th 05, 06:45 PM
Lilasviolet
 
Posts: n/a
Default Formula to count number of dates in an array

I have a column of dates and it will keep on increasing. I need a formula
that will count how many items I have between a start and an end date.

I can do the =if portion but I'm tired of looking for how to get it to add
up how many meet my condition.

  #2   Report Post  
Old April 7th 05, 07:09 PM
Jason Morin
 
Posts: n/a
Default

With dates in column A, start date in C1, and end date in
D1, try:

=COUNTIF(A:A,"="&C1)-COUNTIF(A:A,""&D1)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column of dates and it will keep on increasing.

I need a formula
that will count how many items I have between a start

and an end date.

I can do the =if portion but I'm tired of looking for

how to get it to add
up how many meet my condition.
.

  #3   Report Post  
Old April 7th 05, 07:44 PM
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 7 Apr 2005 10:45:05 -0700, "Lilasviolet"
wrote:

I have a column of dates and it will keep on increasing. I need a formula
that will count how many items I have between a start and an end date.

I can do the =if portion but I'm tired of looking for how to get it to add
up how many meet my condition.


What do you mean, exactly?

To count the number of rows that contain a date between the start and end
dates:

=COUNTIF(dts,"="&StartDate) - COUNTIF(dts,""&EndDate)

where dts is your column containing the dates.

The same logic can be applied to SUMIF if that is more appropriate for your
setup.


--ron


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to calculate # of days between dates, excluding holidays abs2299 Excel Discussion (Misc queries) 8 March 3rd 05 03:21 AM
Is it possible to change the "result of a formula" to a "number? Renee R. Excel Discussion (Misc queries) 0 February 8th 05 03:27 PM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
Count the number of words in a cell! Doom3 Excel Worksheet Functions 4 November 23rd 04 07:00 AM


All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017