Want to take your form-building skills to the next level? 🚀 Checkout my KZbin Course on "Creating Fillable Forms in Microsoft Word: A Step-by-Step Guide," kzbin.info/aero/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs where your frequently asked questions on forms are answered, like how to insert a Submit form button that works with any email client and how to export completed form data to Excel quickly and easily. 💡 The Course includes 15 video lessons, a handy PDF workbook with all lesson summaries and VB code tidbits, and two versions of the Word form template we build together (a behavior-based interview questionnaire form). You can still always access all the free content on my Channel (over 100+ video tutorials). Please note that the KZbin Courses feature is in Beta and currently limited to a subset of Creators. Courses are only available in the United States, South Korea, and India. Viewers must use a computer or Android device to buy a Course. We hope KZbin Courses will roll out to more Creators, devices, and regions in the future! Thank you for taking the time to checkout my Course! You may see some of your other favorite KZbin Creators who have also launched Courses by going to their Channel page and clicking on the "Playlist" tab. Enjoy!
@latishaking27678 ай бұрын
Hey when I use that formula to autofill the dates mine still format the dates incorrectly. Is this because I’m using a Mac? Also my dates doesn’t show when I hover over them but I see they’re the correct date in the top box. I had to just go row by row from Sunday put the date then drag across.
@SharonSmith8 ай бұрын
This may behave differently on Word for Mac. Some of the functionality is different between windows and Mac. Hope you found it helpful!
@slong7349 Жыл бұрын
Hi Sharon, I tried this formula and I get an Error message "You may not use references to other workbooks for conditional formatting criteria. How do I fix this?
@desicafarias3346 Жыл бұрын
I get the same. Did you ever get a response or figure out how to fix it?
@jademoonraven784010 ай бұрын
I also got the same error
@janettesartmood5 ай бұрын
I got the same errors and gave up on this method. I ended up using the SEQUENCE function instead of typing in dates, which works much better.
@pbv1974 Жыл бұрын
Thank you! I'm so glad that you are utilizing simple non macro to create your spreadsheets. I was trying to learn a crash course in Macro, but failed to understand it. However, formulas within excel, is much easier to create. I will definitely be taking your courses and purchasing your documents. This will make my HR life much easier.
@SharonSmith Жыл бұрын
Hi Becky! I'm so glad you found my Channel and that you like my videos. Yes, macros can be difficult to work with! If you are interested in any of my digital downloads, you can find them here: www.youtube.com/@SharonSmith/store and for a limited time, courtesy of KZbin and Spring, you can get a 25% discount on everything, just use this coupon code when checking out: YTShopping25 I currently have one course available on KZbin and that is Creating Fillable Forms in Microsoft Word, and with that you get both a macro AND non-macro version of the template form we create in the course 😉. If you are interested you can learn more about the course here: kzbin.info/aero/PLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs Thanks so much for watching my videos. Best of luck to you!
@pbv1974 Жыл бұрын
@@SharonSmith Yes, I saw that and will be purchasing it. You are a life saver!
@timpayne882111 ай бұрын
This is awesome. Using this I was able to create a template where you can change the year and the pay dates and holidays will change with it. Thank you for this!!
@SharonSmith11 ай бұрын
Awesome! So glad you found it helpful and that you were able to create your calendar. 👍 Thanks for watching!
@caroleplattner42815 ай бұрын
This video was so very helpful! You showed us how to hide the dates that are not in the current month (i.e. in Feb, hide Jan & Mar by formatting with the :::), I am wondering though, how you hide the paydays that are not in the current month? I am assuming the formula would be very similar?
@amyalvar Жыл бұрын
You make everything look so easy! I enjoy your videos. Thank you for teaching. ❤
@SharonSmith Жыл бұрын
Thank you so much, Alma! I'm so glad you like my videos. Thank you for leaving such nice comments and for watching my Channel!
@ThePike57 Жыл бұрын
That's fantastic and simple to follow. Thank you. How would it work if pay date cells are arranged in a grid, say 7col x 4rows?... Having a hair pulling experience
@hassanrozh6579 Жыл бұрын
Great video, thanks so much.
@SharonSmith Жыл бұрын
Thank you so much for watching and for subscribing to my Channel! Glad you found my videos helpful!
@jademoonraven784010 ай бұрын
This was a great video. But, I got an error with the firmula, stating that I couldnt use ranfes. How can this be fixed?
@Ashley-wq6gh10 ай бұрын
I'm having the same issue.
@richardgallighan4941 Жыл бұрын
Great video, thanks you
@SharonSmith Жыл бұрын
Glad you found it helpful! Thanks for watching!
@paparipapari2899 Жыл бұрын
Your face is like an angel and attractive.😘
@SharonSmith Жыл бұрын
Thank you so much for the nice compliment! Thanks for watching my videos!