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))),"#########"))you 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" <
[email protected]> wrote in messagenews:
[email protected]...> 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!>>