View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Summing cells containing dates

Hi,

If your column contains numbers as well as dates then a function may help

Alt+F11 to open VB editot. Right click 'This Workbook' and insert module and
paste this in

Function datecount(rng As Range)
For Each c In rng
If IsDate(c) Then datecount = datecount + 1
Next
End Function

From the worksheet call with
=datecount(A:A)

Mike

"Laura" wrote:

I need to add up the total number of cells in a column that contain entries.
THe entries are dates i..e,

Column A
March 3, 2008
Feb 2, 2008
Aprril 3, 2008

June 14, 2008
(sum should = 4 for the total number of cells with entries in the column)