VBA Basics: Say Goodbye To Date Issues In Excel
Рет қаралды 4,854
Күн бұрын🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN KZfaq MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this tutorial, I will show you how to overcome common issues when working with dates in Excel VBA along with a cheat sheet of all of the date functions you can use in Excel VBA.
⬇DOWNLOAD THIS WEEK'S WORKBOOK TEMPLATE HERE:
bit.ly/WrkngWthDatesInVBA_WkbkDl
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
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:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#ExcelVBA #DatesInVBA #DateFunctions #CheatSheet
@ExcelForFreelancers 2 ай бұрын
🔥 Start Your Journey To Financial Freedom: Save Up To 65% Freelancer's Academy + Bonus Product! ► bit.ly/FreelanceAcademyYtCom
@AsadAli-jx9kf 2 ай бұрын
This Channel is so under-rated, the way of teaching, the way of explanation and the developments are unbelievable.
@ExcelForFreelancers 2 ай бұрын
Thank you so very much, I really appreciate that Asad and I am happy to help and share. Thank you for your Likes, Shares & Comments. It really helps.
@ExceltechBI 2 ай бұрын
I love your mentorship. It's made a whole lot of difference in my excel automation process.. Thanks again
@ExcelForFreelancers 2 ай бұрын
Thank you so very much, I really appreciate that
@sircorn4248 2 ай бұрын
Manipulating Dates in VBA is always tricky. Thank you for this all-in-one lesson.
@ExcelForFreelancers 2 ай бұрын
For sure, you are very welcome and very happy to help.
@SyedMuzammilMahasanShahi 2 ай бұрын
Thank you so much Randy for this amazing video.
@ExcelForFreelancers 2 ай бұрын
For sure, you are very welcome Syed and I am glad you enjoyed it
@muhammadkausar2842 2 ай бұрын
Hello Randy! How are you? Hope u well.... Next saturday please make a video on "command button, "text box" events. and how to add more like "Toggle Button" "Listview" to the tool box Please a humble request
@ExcelForFreelancers 2 ай бұрын
HI and thanks i have most of that in my Basic Userform training here: kzfaq.info/get/bejne/qLqdpJB2rtHdmWQ.html Beyond that is more advanced and i cover thata in one of my advanced lessons on userforms I hope this helps and thanks so much.
@SMagsoud 2 ай бұрын
Great job.
@ExcelForFreelancers 2 ай бұрын
Thank you so very much, I really appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
@moayadhboubati3495 2 ай бұрын
thank you for this randy, can you make an advanced search box with first litters of first or second word instead of data validation , so i can search and add to invoice.
@ExcelForFreelancers 2 ай бұрын
Hi and thanks very much. This can be done in a userform. You can find that training here: kzfaq.info/get/bejne/g6ydl6yCl7emlmQ.html I hope this helps and thanks so much.
@keithturner4036 2 ай бұрын
What about CDate?
@ExcelForFreelancers 2 ай бұрын
Thanks so much for the feedback Keith. I have subsequently added the CDate to the cheat sheet, which is also a great function that converts strings into dates. Thank you for your Likes, Shares & Comments. It really helps.
@vannhiem8021 2 ай бұрын
How to make a job shop file
@ExcelForFreelancers 2 ай бұрын
Hi and thanks very much for your comment. I am not sure what a 'job shop file' is so you would have to go into a lot more detail. I hope this helps and thanks so much.
超人夫妇
Рет қаралды 43 МЛН
Meraz Mamun - Analytics
Рет қаралды 928
Excel For Freelancers
Рет қаралды 8 М.
Excel For Freelancers
Рет қаралды 16 М.
Excel For Freelancers
Рет қаралды 19 М.