software

Hi all,

I am trying to count a number of dates if they are between a certain time
scale.
For example in column A I have a list of dates spanning many years. In B1 I
have Today() and in C1 I have B1-365. I need a formula to count the amount
of dates I have between B1 and C1.
Can anyone help me with this?

Cheers

SPL
SPL,

=COUNTIF(A:A,quot;gt;=quot; amp; C1)-COUNTIF(A:A, quot;gt;quot; amp; B1)

HTH,
Bernie
MS Excel MVPquot;PH NEWSquot; gt; wrote in message
...
gt; Hi all,
gt;
gt; I am trying to count a number of dates if they are between a certain time
gt; scale.
gt; For example in column A I have a list of dates spanning many years. In B1 I
gt; have Today() and in C1 I have B1-365. I need a formula to count the amount
gt; of dates I have between B1 and C1.
gt; Can anyone help me with this?
gt;
gt; Cheers
gt;
gt; SPL
gt;
gt;
Cheers Bernie, much obliged

SPL

quot;Bernie Deitrickquot; lt;deitbe @ consumer dot orggt; wrote in message
...
gt; SPL,
gt;
gt; =COUNTIF(A:A,quot;gt;=quot; amp; C1)-COUNTIF(A:A, quot;gt;quot; amp; B1)
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;PH NEWSquot; gt; wrote in message
gt; ...
gt; gt; Hi all,
gt; gt;
gt; gt; I am trying to count a number of dates if they are between a certain
time
gt; gt; scale.
gt; gt; For example in column A I have a list of dates spanning many years. In
B1 I
gt; gt; have Today() and in C1 I have B1-365. I need a formula to count the
amount
gt; gt; of dates I have between B1 and C1.
gt; gt; Can anyone help me with this?
gt; gt;
gt; gt; Cheers
gt; gt;
gt; gt; SPL
gt; gt;
gt; gt;
gt;
gt;