About Us

taimysho0

Quote:

Originally Posted by Claus Busch

Hi,

Am Tue, 4 Mar 2014 17:43:08 +0000 schrieb taimysho0:

now that i have these in date format, do
you know how i can do a count of all dates that are the same so i can
plot them in a graph?

in C3:
=COUNTIF(B:B,B3)
and copy down

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

thank you so much for your help! the last question is, in your date modify code above, how would i modify it so that the results displayed are always within the last 90 days? so for example anything older than 90 days gets deleted. thanks so much!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
plot schedule-type data in graph, date and times as x & y axes	weblun	Charts and Charting in Excel	1	May 6th 09 09:30 AM
How to plot Date Ranges on Same Graph	JJ	Charts and Charting in Excel	2	April 7th 09 11:03 PM
Can't graph data with Date Format with hours	BRB	Excel Discussion (Misc queries)	2	August 13th 08 10:13 AM
How to make xy plot of date format data in both columns	Pardeep Mohan	Charts and Charting in Excel	1	August 30th 06 09:13 AM
How do I convert Dates from Text back to Date format using macros	Frank Kabel	Excel Programming	0	July 29th 04 03:40 PM

Menu

About Us