Counting Dates

A

AnnaV

I have 4 different cells that have dates in them C5, D5, E5, F5 and
want to enter a formula in G5 that counts the dates. If there is a dat
in C5 I want it to count 1, if there is a date in D5 I want it to coun
another 1 and so on. How do I do this
 
D

Don Guillett

try this by picking a date you like

=COUNTIF(N9:N19,">"&DATEVALUE("04/25/04"))
 
A

AnnaV

It worked thanks very much!

It didn't even occur to me that it could be so simple. You should hav
seen the formulas I was trying to dream up
 
Top