In this video, we use an Excel formula to return the week number of any given date. Just enter a date and the formula returns the week number of that date, from a specified start date.

Excel has a function called WEEKNUM. And although useful, this is limited to finding the week number of a date from the 1st January of that year.

The formula in this video tutorial though will enable you to specify a start date, and we can count how many weeks until another date.

You could even reverse the formula and get a week countdown until a due date or deadline.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.