Dear Surya,
SAM is right
but If you want to Count only Date
Please try it and see attached sheet..i hope it will help to u
Function Countonly_date(rng As Range)
For Each abc In rng
If IsDate(abc) Then
Countonly_date = Countonly_date + Application.WorksheetFunction
Unless I'm mistaken, is this what you are looking for?
=COUNT(A1:A3)
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 17, 2011 at 8:50 PM, Mr Excellent wrote:
> Hi All,
>
> I have three different dates in a Column A , suppose say in Col A i have A1
> as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar
Hi All,
I have three different dates in a Column A , suppose say in Col A i have A1
as 1- Dec -2010, A2 as 11- Jan-2011,A3 as 1- Mar -2011 then i need a count
of number days as *3* in the cell A4 any idea?
Thanks
Prasad.
--
---