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....