Yes, I don't know why from time to time my posts get misformatted. I have
asked in the outlook express newsgroup, but with no luck.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
Oh! I read only the part of your post, because your post is showing in
MSDN
Website as unformatted text except the first line. But now I understood
that
the formula I have suggested will not give the correct answer when the
count
goes beyond 31. Thanks for your guidance David Sir..

--------------------
(Ms-Exl-Learner)
--------------------


"David Biddulph" wrote:

I assume that the VALUE(TEXT(DAY(...)) construct is a little Christmas
joke?

Instead of

=VALUE(TEXT(DAY(COUNTIF(A:A,""&DATE(2009,11,14))-COUNTIF(A:A,""&DATE(2009,11,20))),"#########"))yo u
can use just
=COUNTIF(A:A,""&DATE(2009,11,14))-COUNTIF(A:A,""&DATE(2009,11,20))
though you may need to format the result as General or Number if
Exceldecides to format it as a date.The difference is that if the answer
is more than 31 my formula will stillwork, but yours won't.--David
Biddulph"Ms-Exl-Learner" wrote in
... Assume
that you are having the Dates in A Column and do you want to getthe
number of days between 15.11.2009 to
20.11.2009.=VALUE(TEXT(DAY(COUNTIF(A:A,""&DATE( 2009,11,14))-COUNTIF(A:A,""&DATE(2009,11,20))),"#########"))
In your example the dates are entered with Full stop (.) instead of /
or - so I think it will not treated as dates. So replace the Full Stops
to /or - for converting it into Dates. Remember to Click Yes, if this
post helps!
-------------------- (Ms-Exl-Learner) --------------------
"Manikandan" wrote: I have a date range from month first to end of
month. I want to count noof entries from that list which range from 10th
to 15th. For eg. a liststarting from 01.11.2009 to 30.11.2009. I want to
count no of entries of daterange from 15.11.2009 to 20.11.2009. Please
help me....

.