What exactly do you want to show?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:6323530f33d3c@uwe...
I've figured out how to count the number of dates, but how can i just show
the date if there is a date used.

I can use a pivot but i really need to have a formula driven sheet.



LoB 7/3/06 7/5/06 7/7/06 7/10/06
CBNA 7 1 2 8
CFNA 3 14 29 7

--
Message posted via http://www.officekb.com