Counting Dates

[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

 

[Frank Kabel]

Hi
if these cells are either blank or have a date value try
=COUNTA(C5:F5)

 

[Don Guillett]

try this by picking a date you like

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

 

[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