software

Hi everyone,

After a bit of help with this statement

=COUNTIF(J21:J27,(quot;gt;A2,lt;J2quot;))

All the cell references are the same custom date format ([$-809]d mmmm yyyy;@)
What I want to do is count the number of dates that fall between the A2 and
J2 references at the moment I get a '0' return.

Any suggestions greatly recieved

MTIA

Souchie40

try sumproduct
=sumproduct((j21:j27gt;a2)*(j21:j27lt;j2))

--
Don Guillett
SalesAid Software

quot;souchie40quot; gt; wrote in message
...
gt; Hi everyone,
gt;
gt; After a bit of help with this statement
gt;
gt; =COUNTIF(J21:J27,(quot;gt;A2,lt;J2quot;))
gt;
gt; All the cell references are the same custom date format ([$-809]d mmmm
gt; yyyy;@)
gt; What I want to do is count the number of dates that fall between the A2
gt; and
gt; J2 references at the moment I get a '0' return.
gt;
gt; Any suggestions greatly recieved
gt;
gt; MTIA
gt;
gt; Souchie40
Thank you for a speedy response that does the trick

Souchie40

quot;Don Guillettquot; wrote:

gt; try sumproduct
gt; =sumproduct((j21:j27gt;a2)*(j21:j27lt;j2))
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;souchie40quot; gt; wrote in message
gt; ...
gt; gt; Hi everyone,
gt; gt;
gt; gt; After a bit of help with this statement
gt; gt;
gt; gt; =COUNTIF(J21:J27,(quot;gt;A2,lt;J2quot;))
gt; gt;
gt; gt; All the cell references are the same custom date format ([$-809]d mmmm
gt; gt; yyyy;@)
gt; gt; What I want to do is count the number of dates that fall between the A2
gt; gt; and
gt; gt; J2 references at the moment I get a '0' return.
gt; gt;
gt; gt; Any suggestions greatly recieved
gt; gt;
gt; gt; MTIA
gt; gt;
gt; gt; Souchie40
gt;
gt;
gt;

glad to help

--
Don Guillett
SalesAid Software

quot;souchie40quot; gt; wrote in message
...
gt; Thank you for a speedy response that does the trick
gt;
gt; Souchie40
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; try sumproduct
gt;gt; =sumproduct((j21:j27gt;a2)*(j21:j27lt;j2))
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;souchie40quot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi everyone,
gt;gt; gt;
gt;gt; gt; After a bit of help with this statement
gt;gt; gt;
gt;gt; gt; =COUNTIF(J21:J27,(quot;gt;A2,lt;J2quot;))
gt;gt; gt;
gt;gt; gt; All the cell references are the same custom date format ([$-809]d mmmm
gt;gt; gt; yyyy;@)
gt;gt; gt; What I want to do is count the number of dates that fall between the A2
gt;gt; gt; and
gt;gt; gt; J2 references at the moment I get a '0' return.
gt;gt; gt;
gt;gt; gt; Any suggestions greatly recieved
gt;gt; gt;
gt;gt; gt; MTIA
gt;gt; gt;
gt;gt; gt; Souchie40
gt;gt;
gt;gt;
gt;gt;