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