Перейти к содержимому

Automate ANY Date Calculation in Seconds + FREE Cheat Sheet

Excel For Freelancers

0:00 / 0:00

Automate ANY Date Calculation in Seconds + FREE Cheat Sheet

7 242 просмотра · 2 года назад
Excel For Freelancers
1 млн подписчиков
7 242 просмотра · 2 года назад
This VBA dates lesson finally clears up Excel's most confusing data type. Dates have a way of causing confusion in VBA code that doesn't show up until something calculates incorrectly. This walkthrough shows you how to work with dates in VBA, including formatting, calculations, and comparisons. You'll see exactly how the code handles a date value correctly every time. 👇 GET THE FREE FILES FOR THIS VIDEO: https://www.excelforfreelancers.com/w... 🔥OWN 550+ TEMPLATES & WORKBOOKS IN ONE PACK👉 https://www.excelforfreelancers.com/u... 📌 LEARN VBA FROM SCRATCH WITH THE ULTIMATE VBA COURSE 👉 https://www.excelforfreelancers.com/u... 📌 ACCESS 500+ READY-TO-USE VBA MACROS WITH MY DEVELOPER’S LIBRARY👉 https://www.excelforfreelancers.com/u... 😎 JOIN OUR ELITE MEMBERSHIP: PREMIUM TRAININGS, RESOURCES & COACHING 👉https://www.excelforfreelancers.com/e... 🚀 GET YOUR OPERATIONS UNDER CONTROL — 3 Spots Open This Quarter👉 https://www.excelforfreelancers.com/b... 🛠 NEED THIS BUILT FOR YOUR BUSINESS OR NEEDS? Get Expert Customization Help 👉https://www.excelforfreelancers.com/C... 🛒 Browse All Excel And AI Templates, Courses & Tools: https://www.excelforfreelancers.com/shop ⏱ TIMESTAMPS: 0:00 – Introduction 1:11 – Overview 3:34 – Basic Date Macro 8:38 – Add Date Diff Macro 16:11 – Date Diff Macro 22:08 – Advanced Filter With Dates 27:10 – Return Date Value 👥 JOIN OUR COMMUNITY: https://www.excelforfreelancers.com/E... 🔗 LinkedIn:   / excelforfreelancers   😎 Facebook:   / excelforfreelancers   About: I'm Randy Austin — Excel developer and business systems builder. I help business owners and entrepreneurs replace expensive software subscriptions with powerful, done-for-you Excel templates they can customize and own forever. New training every week. #excel #exceltutorial #excelforfreelancers #workingdatesvba #excelvba Thanks so much for your continued support, Randy Austin