AutoFill Dates in Excel - Days, Weekdays, Months & Years

Click here to view this tutorial on my website www.bluepecant...
This video tutorial explains how to use Excel's autofill feature to automatically create a list of dates. The dates can be made to be sequential, or follow a different pattern such as weekdays, same day every month, same day every year, every 7 days etc.
Simple Sheets Excel University - Try for Free: the All Inclusive Course Bundle with over 48+ Lectures improving your proficiency & efficiency with Excel. www.simpleshee...
Unlock the Power of Excel. 100+ Pre-Built Excel Templates - Try 5 for Free. www.simpleshee...
Purchases at Simple Sheets help support this channel - thanks!
------------------------

[@rustyzi345]

Liked because you got to the point right off the bat and I did not need to sit through a pointless introduction about who you are.

[@jaymoney1224]

So true. Hurry up and Let me get back to this money 😂😂

[@orangeblock3792]

EXACTLY!!!

[@Gheorghe99]

I was wracking my brain trying to figure out how to do a W/C list every Saturday for 2024 and almost gave up thinking that I would have to enter it in two columns by hand. And then I stumbled upon your video and Voila - in few seconds I got my list. Thanks so very much!

[@s.d.melcher]

I know short videos aren’t the greatest for UA-camrs, but thank you so much for this one! I KNEW it was a super simple process to get dates to auto update but my mind went blank and I couldn’t remember to use that little + and drag down. THANK YOU! 💞👍😁🌺🐶💞

[@ChesterTugwell]

Glad it was helpful!

[@lorrinaallred9698]

THANK YOU! Such an easy solution to something that would have taken me hours to figure out by myself! Thank you for being concise and simple and getting straight to the point and showing several different options.

[@robertkajita1531]

Awesome, precise information, good pace, and clear to watch. Thank you.

[@maxkerschbaumer9077]

ASMR on this video is through the roof, for anybody out there caring.

[@RustyBeez]

Currently at my hospital facility. Trying to figure out how to do fates all the way down in order. THANK U U SAVED US so we can get back to our patients!

[@ChesterTugwell]

Glad I could help!!!

[@varneyfg]

You are the best. Thank you for this excellent video. Others try to teach formulas which can be absurd for someone who just needs a quick way to do it.

[@shabanaballo2442]

Thank you very much within a second i got it.

[@ujkos_who]

all you need, no bullshiting, just pure info, love it

[@MariaruthOnava]

That pointer from white to black save my time thanks.....

[@OhioFootHills]

Answered my question in 34 seconds. You are faster than AI. Thanks. ;)

[@shellbelle2212]

YOU ARE SOOOOO GREAT. i NEEDED THIS info today!!! Thank you.

[@FxSalvation]

wonderful narrating voice

[@louisepurchase4215]

Really helpful.Thanks Chester. Basics always good when learning.

[@Thundernixx]

You really saved my day, I'm feeling like a super hero discovering a new power using these options

[@subhasisj]

Perfect to the point video. Just earned a subscriber.

[@martinconnolly7815]

Straight to the point, excellent.
Thank you

[@ZSBBR]

obožavam administraciju i evidenciju❤

[@shalazashim7183]

To the point no irrelevant stuff

[@elvinamae0416]

very helpful. thank you! i just purchased my very first laptop! keep on educating!

[@KrahyzHD]

Thanks mate, turned my 10 minute issue into a 20 second explanation

[@ari86ful]

Very simple and easy. Thank you

[@suzannekramer4134]

Exactly what I was looking for. Thank you!

[@ChesterTugwell]

You are welcome!

[@mrCetus]

Bless this video, straight to the point

[@ShakeelAhmed-go8nm]

Amazing in less than 3 minutes, you have done great and amazing job. Tremendous job..... Well Done

[@pique3124]

I wonder why it doesn't work for me. When I try it even with the black cross, it just copies the same date over and over

[@cardalmc1523]

Hi, I was getting the same result with the function =today(), but once I inserted the date manually, then find the black cross it auto-incremented.

[@michalroesler]

First minute of the video - It doesn't work form me either. I'm trying to fill series to the right. The year is incrementing instead of the day.

[@a.meenakumari4174]

@@cardalmc1523 Thank you so much

[@zachbeauchamp8990]

Best video ive found on excell thanks for being so direct

[@ChesterTugwell]

You're very welcome!

[@MKRodz]

Thank you so much! So grateful to find your video. So easy. I am the w/c lol I will be following you now.😍

[@beigelavender]

Better than the official website because it actually works !

[@adithya1577]

Thank you so much sir😀😀

[@juanitavandeweerd699]

Thank you so much for the video. I'm following what you are saying, but for some reason when I highlight the two cells that I want repeated (in this instance w/c), it will not give me an autofill option, it just turns my arrow black. When I then pull down, it will just keep repeating the two dates I have put in. I did for Friday dates in a row, highlighted them, arrow turn black and I drag and it will just repeat the exact for dates that I've put in. What am I missing please?

[@ellentsoeu1393]

Very helpful thank you so much

[@plorr2FYI]

So helpful. Managed to create my timesheet. Really appreciate the video, Thank you

[@hutchm92]

Outstanding job! thank you!

[@elidixon5758]

You got yourself a new follower

[@DjofDeVos]

you are a GOD , good heplfuyll videos !
|thanks !

[@celticlofts]

Thanks a lot, it helped loads.

[@alterhit]

Control Semi Colon - what a winner - thanks.

[@mariaelhaje]

Thank you, you made my frustration into a wonder!

[@jacobnduya798]

Thank you so much this video is very helpful.

[@KhalidMehmood-ey9hh]

Thank you so much. You helped me save a lot of time . Thanks again

[@philiphiggins4822]

Very helpful for a dummy like me thanks for taking the time too make the vid!

[@sambendasilva8174]

Awasome bro 😎👌👍 Thank you🙏

[@adekunlesalami3506]

Nice tutorial

[@andycarman0129]

You have just saved me about 3 hours of my life 🙏🙏👍

[@gisselcalle1636]

SO HELPFUL THANK YOU

[@ChesterTugwell]

Glad it helped!

[@ClivesEnglishCorner]

Thank you this helped a lot

[@michaelsimmons7773]

Thanks - very helpful!

[@FirstDan2000]

Thanks for the tutorial. Can you help, why does the Year increase incrementally, and not the Date?

[@FirstDan2000]

When I follow the tutorial I don't get the same results. I get the year increasing instead of the date and I'm unable to figure this out.
Have you done a video that covers this difficulty?
Thanks in advance.

[@dariuzenn]

Sir, you are a life saver. Thank you !

[@Youstaofficial]

Thanks mate

[@anylength2215]

thanks, mate, you saved me a lot of time.

[@stefank4274]

THIS IS EXACTLY WHAT I WAS LOOKING FOR! THANK YOU

[@tarunkalra3924]

Great video bud!

[@justinryan1300]

Great job, you are a star!

[@alenaatoutlemonde4036]

Huge help. Great for google sheets as well.

[@hanskabdulla9116]

thank you so useful I used today your information from Kurdistan

[@jandekoekepan8813]

Nice, short and informative video!

[@AbrarManzoor]

it saved me tons of time.

[@rvr2882]

Thank you!

[@iamawhistlergirl]

How do I format for one week increments for "written" day of week format - sat Jan 1 2022 +7 days

[@thealokspoetry4596]

Thanks you for this

[@jelajahsebanten]

Good tutorial my brother

[@dashag2342]

Is there keyboard-commands that can do the same?

[@marshallhosel1247]

Great job

[@hibanour1987]

You are my savior.. Thank u thaaaank you

[@hanocky]

I suppose the autofill option is not available for the older versions.

[@pancakewalrus99]

that command is really good to know!!! thank you. is there a command that will get it to read for example November 28th, 2021 instead of just the digitals 11/27/2021 for example

[@AnuLk-r9l]

Thank you so much❤️🥰

[@adrianchineaamoros3230]

that was awesome. Thank you so much sr!

[@mikeschannel6454]

What if I need week days sequenced in multiples of 2 or 3? for example MM,TT,WW,THTH,FRFR.

[@a1moto283]

Great information - created timesheets for my department

[@hillelpaley6813]

I don't have the "auto-fill options", instead I have "quick analyze". What should I do?

[@dudeicle4306]

is there a way to auto fill each box with an entire 7 day week? so as to have week 1 week 2 week 3 sort of thing?

[@geraldbull9272]

Many thanks, no hype, just explained in a calm manner.

[@smoochesluvp]

2024 still needed thanks!

[@pranavbakare8922]

Easy and simpler when you explain 🔥💯

[@NualaOSullivan20]

I'm struggling to do this across the top of the excel sheet, any tips please?

[@anchit2604]

easily explained. thanks

[@ronitkarkera8195]

Thanks man.

[@orangeturtle2737]

How do you populate a review date in advance.
So for example annual review commence 10/08/2022 how would I get the 6 month advance date in the next row?
Not sure if I explained that well.

[@ethiolifetips2367]

Thank you so much

[@jantendo6809]

Good Tutorial Thank you

[@southerncomfortuk]

Brilliant thank you 🙏

[@nicholasrushing4156]

Thank you!!

[@shahzadmughal7666]

thanks, it helps

[@motevatshots6934]

Help full vedio thank you

[@buchu4993]

I like your video. The 3rd column, week commencement, i tried it on my laptop by selecting both intervals but the white cross couldn't change to black as a result couldn't drag down. Any other method?

[@Makstalds143]

THANKS!

[@msanchez1210]

Thank you 🙏🏻 saved my life

[@rosnniejenging1910]

Awesome 👍 thanks for this vid

[@samueljh3]

This saved me a lot of time. Thank you!

[@derektravis8384]

Thanks you.... Perfect

[@yashsingh3913]

Very helpful

[@chingchen5062]

What if there are cells between two dates in the same column. How to do it when I want spaces between dates

[@eagle6769]

Thank you very much! 💐 😊

[@JM-tf6qs]

That was a life saver!

[@TychiBalls]

i want to type January in one cell and the year 2022 in another cell then I want all 31 days of that month to auto populate in other cells. Is this possible? I want to be able to do this for each month. February only usually has 28 days in a year and so I would like it to know not to go up to 31 days for that month. This would be great if its possible through macros or VBA.

[@RAVI9700203330]

It doesn't work for me. While dragging years are repeating. What to do