View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=COUNTIF(A1:A100,"<" & NOW())

--
Regards
Frank Kabel
Frankfurt, Germany

Aviator wrote:
In a specific cell, I am wanting to count a series of dates with each
date less than NOW() to be worth +1 and each date equal to or more
than NOW() to be worth 0.

Thank you,

Aviator