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