Posted to microsoft.public.excel.misc

Matthew Tyrus Matthew Tyrus is offline

external usenet poster

Posts: 1

Count Dates

I have a list of dates in the following format MM/DD/YYYY.

1/11/2008
1/12/2008
1/30/2008
1/10/2008
1/10/2008
1/10/2008
1/12/2008
1/6/2008

I want to know how many times a date falls in-between a certain week. For
instance, countif(range,"=1/1/2008","<=1/6/2008"). It should be 1.

Any help?

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count on dates	Vijay DSK[_2_]	Excel Worksheet Functions	16	October 20th 08 04:22 PM
I want to count the total Number of dates between two dates How?	seshu	Excel Worksheet Functions	3	February 7th 08 05:41 PM
Count dates	poolgirl	Excel Worksheet Functions	2	May 7th 07 07:07 PM
need to convert list of dates to count no. of dates by week	neowok	Excel Worksheet Functions	13	January 30th 06 03:54 PM
How do a count dates?	Peo Sjoblom	Excel Discussion (Misc queries)	0	December 27th 04 05:13 PM

All times are GMT +1. The time now is 08:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us