Re: $$Excel-Macros$$ Count days in a Col

2011-10-17 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Count days in a Col

2011-10-17 Thread Sam Mathai Chacko
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

$$Excel-Macros$$ Count days in a Col

2011-10-17 Thread Mr Excellent
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. -- ---