Excel Formula - Find the Week Number from any given Date
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!