Thread: Another Excel question!
View Single Post
Old 18-10-2006, 12:07   #30
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 44
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Another Excel question!
Don't use pivot tables much myself so there may be an easier way.

But if you add another column use the following formula to grab just the date...

=TEXT(B2,"dddd, mmmm dd, yyyy")

and then do the count on this column,
gazzae is offline   Reply With Quote