Count Values Between Two Dates - Excel COUNTIFS Function

Computergaga April 24, 2017
Video Thumbnail
Computergaga Logo

Computergaga

@computergaga

About

Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work. Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI. If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody. Who am I? My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas". I love working with data and helping people improve their Excel skills and save time. I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.

Video Description

In this video tutorial, we count values between two dates on a spreadsheet using the COUNTIFS function. The two dates are entered onto the spreadsheet making the date range easy to adjust in the future without having to edit the formula. Master Excel today with this comprehensive course - https://bit.ly/UltimateExcel The criteria for the COUNTIFS function must either be entered into a cell, or entered as text. In this example, we did a bit of both. The date was in a cell, but the testing part of the criteria was entered as a string and joined. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1