Thread: COUNTIF q re dates and blank cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dennis dennis is offline
external usenet poster
  
Posts: 202
Default COUNTIF q re dates and blank cells
=COUNTIF(D3:D100,"<" & TODAY())

"Jock" wrote:

I am trying to create a formula which will look at dates (D3:D100) and count
ones which are earlier than TODAY() but to ignore blank cells too.

Thanks
--
Traa Dy Liooar

Jock
Reply With QuoteReply With Quote