How to AutoFill WEEKDAYS in Excel #shorts

Do you need to create a list of dates in Excel that exclude weekends? In this video I'll show you a trick on how to use the Fill Series in Microsoft Excel to create a list of dates that only include weekdays.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[Michael_Alaska]

Ctrl + Shit + : gave me the time. Ctrl + : gave me the date. Thank you for the fill tip.

[pasokhjoo]

The only one of myriads of excel pages that is actually clear, precise, and helpful.

[PurplePegasus]

Madam, you are literally going to get me a raise and a promotion! THANK YOU!!

[Tommie_Rogers]

You can also enter today's date and then press and hold the Right mouse botton and then drag. When you stop Excel will ask you what you want, "days", "weekdays", ", months" or "years". Happy Excelling and thanks again for a GREAT channel.

[sahralsahri]

يومين من كل اسبوع
ممتاز رائع
👍⭐⭐⭐✨
Wonderful Excellent

[Tommie_Rogers]

Hi Leila, thanks for the info, but one small correction, if I may. To enter today's date, it is Ctrl + ;. Ctrl + Shift + :/; will give you the time right now.

[pascalejacquelinepetit]

Always great "Shorts" from Leila

[showki]

Your shorts are very useful to me mam.... Thanks 🙏👍

[cindyrella]

Very helpful Laila, thank you very much

[chrism]

Thanks Leila, I never thought to do that!

[navneetvyas]

Thank you for sharing such a helpful tip

[BGelvitz]

You’re my kind of rockstar! Thank you!

[shilpamanmohan]

Thanks a ton, God bless you. Thanks again.

[petr]

Another tip: Select a range of cells from start (cell with value 1) to the end (cell with value 2). The Series dialog fills Series in Columns and divides intervals into equal sections (fills in Step value). It will generate x-axis values for the graph, for example.

[vijayarjunwadkar]

Loved this! I was doing this in a very inefficient way, thanks for this super useful tip! 😊👍

[bgood]

Thank you! I've wondered if there were an easy way to do this for some time.

[manojraghavan]

Leila, you must call your channel as 'Applied <Tool Name>. Coz most of your videos are immensely useful for real world problems. Thanks.

[pilotgundul]

Thanks... Never had this kind of tasks.. But it really helpful