Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

Excel: Days Between Dates
By Richard Rost     14 years ago

Q: Hi Richard. I need some help. I'm no excel pro! This is what I need: I want to know the average the product is being bought within Excel. eg: product X is being bought every X months

Product# Date Purchased Date Purchased Date Purchased
100.0 2007-08-22 2007-11-20 2008-04-13
602A.0 2007-06-25 2007-10-15 2008-01-05

A: Good question.

If you have two dates, let's say 1/1/2008 and 2/1/2008, those days are 31 days apart. You can find this by simple subtraction. For example, if you put those values in cells A1 and B1, respectively, then you can just put this in C1:

=B1-A1

Now the result is going to say 1/31/1900, but that's OK. Just right-click on the cell and go to FORMAT CELLS and reformat that value to NUMBER, and now it's represented in the "number of days" between those two dates.

Knowing how to do that, now the rest of your problem is just mathematics... add up the total number of days, and divide by the number of sales, and you have the average sales per day (or month, just divide by 30 or 31).

I cover this topic in my Excel 232 class: /site/courselist/excel/excel232

Hope this helps

Kirk
14 years ago
I really learned something from this!!
Thanks!!  I will examine more and will probably send some of my own in.

Start a NEW Conversation
 Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

 You may want to read these articles from the 599CD News:
 1/11/2022 Excel Fast Tips 1/7/2022 Count Cells by Color 1/7/2022 Excel VBA 1/7/2022 Excel Count by Color 12/26/2021 Conditional Formatting 12/9/2021 Excel 2003 Quick Start 1 12/9/2021 Excel 2003 Expert 232 12/9/2021 Excel 2003 Expert 231 12/9/2021 Excel 2003 Expert 230 12/9/2021 Excel 2003 Expert 224

 Learn  Access - index Excel - index Word - index Windows - index PowerPoint - index Photoshop - index Visual Basic - index ASP - index Seminars More... Customers  Login My Account My Courses Lost Password Memberships Student Databases Change Email Info  Latest News New Releases User Forums Topic Glossary Tips & Tricks Search The Site Code Vault Collapse Menus Help  Customer Support Web Site Tour FAQs TechHelp Consulting Services About  Background Testimonials Jobs Affiliate Program Richard Rost Free Lessons Mailing List Order  Video Tutorials Handbooks Memberships Learning Connection Idiot's Guide to Excel Volume Discounts Payment Info Shipping Terms of Sale Contact  Contact Info Support Policy Email Richard Mailing Address Phone Number Fax Number Course Survey
Keywords: excel difference between two dates tips  PermaLink