Excel Tip: Count Items Between Dates

News User Comments History Notify Me

9/11/2008 1:06:40 PM
Excel Tip: Count Items Between Dates
By Richard Rost

Q: I have a bunch of dated invoices. I need to count how many orders were placed between two dates (say, September 1st and September 30th). How can I do this in Excel?

A: You can use the IF and AND functions to take care of this problem. See this page for full details:

/tips/excel/count-between-two-dates

And of course you need to know how to SUM up a column - but that's easy. :)

Permanent Link
Keywords: excel tips between dates tips if and

Post Reply

excel user furmula Comment from Richard Rost @ 6/13/2009

I cover this topic in Excel 232.

Show Just This Thread Post Reply

excel user furmula Comment from kana @ 6/13/2009

Ex. DOB = 26-06-1977
Today = 13-06-2009
How many year old at time
excel user formula

Show Just This Thread Post Reply

Comment from Richard Rost @ 9/17/2008

Yes, most of my classes also have HANDBOOKS that you can print out (or order them printed from us) that you can provide to your students while you, perhaps, play the video on your overhead. I'll send you some samples.

Show Just This Thread Post Reply

Comment from jonathan Smith @ 9/15/2008

Hi Richard not all of my computers at school have video capability. Do you have handouts or worksheets i can handout to students so they can learn from these. I am looking to purchase your resources because i have none for this years computer class.

THanks

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 8+8:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard