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. :)

excel user furmula Link  Richard Rost  12 years ago I cover this topic in Excel 232. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

excel user furmula Link  kana  12 years ago Ex. DOB = 26-06-1977 Today   = 13-06-2009 How many year old at time excel user formula Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Link  Richard Rost  13 years ago 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. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Link  jonathan Smith  13 years ago 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. Read More... THanks Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.