Hi!

Try this:

Assuming the range in question is B1:J10.

Dates are really just numbers formatted to look like a date, so in essence
you just have to "test" for the presence of a number in your columns. This
could lead to incorrect results if you have other numeric values in the
columns that are not dates:

=SUMPRODUCT(--(COUNTIF(OFFSET(B1:B10,,COLUMN(B1:J1)-COLUMN(B1)),"0")0))

Biff

"mango7" wrote in
message ...

I want to create a column which will give me a total of the number of
columns which contain a date. Therefore count the columns not the data
in the cells. Any ideas?


--
mango7
------------------------------------------------------------------------
mango7's Profile:
http://www.excelforum.com/member.php...o&userid=29529
View this thread: http://www.excelforum.com/showthread...hreadid=492293