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

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 191

  • @rustyzi345
    @rustyzi345 3 года назад +124

    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
      @jaymoney1224 2 года назад +1

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

    • @orangeblock3792
      @orangeblock3792 2 года назад +1

      EXACTLY!!!

  • @Gheorghe99
    @Gheorghe99 10 месяцев назад +3

    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
    @s.d.melcher Год назад +15

    I know short videos aren’t the greatest for RUclipsrs, 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! 💞👍😁🌺🐶💞

  • @lorrinaallred9698
    @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.

  • @RustyBeez
    @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!

  • @robertkajita1531
    @robertkajita1531 6 лет назад +32

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

  • @varneyfg
    @varneyfg 4 года назад +9

    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
    @shabanaballo2442 Год назад

    Thank you very much within a second i got it.

  • @pique3124
    @pique3124 5 лет назад +29

    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
      @cardalmc1523 4 года назад +2

      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
      @michalroesler 3 года назад +2

      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
      @a.meenakumari4174 3 года назад

      @@cardalmc1523 Thank you so much

  • @OhioFootHills
    @OhioFootHills Год назад

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

  • @FxSalvation
    @FxSalvation 2 года назад +1

    wonderful narrating voice

  • @maxkerschbaumer9077
    @maxkerschbaumer9077 Год назад

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

  • @shellbelle2212
    @shellbelle2212 2 года назад

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

  • @ujkos_who
    @ujkos_who Год назад

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

  • @MariaruthOnava
    @MariaruthOnava Год назад

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

  • @louisepurchase4215
    @louisepurchase4215 5 месяцев назад

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

  • @martinconnolly7815
    @martinconnolly7815 4 месяца назад

    Straight to the point, excellent.
    Thank you

  • @the.realjackson5899
    @the.realjackson5899 13 дней назад

    thanks man u deserve all the good

  • @Thundernixx
    @Thundernixx Год назад

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

  • @subhasisj
    @subhasisj 9 месяцев назад

    Perfect to the point video. Just earned a subscriber.

  • @ari86ful
    @ari86ful 9 месяцев назад

    Very simple and easy. Thank you

  • @elvinamae0416
    @elvinamae0416 2 года назад

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

  • @ZSBBR
    @ZSBBR Месяц назад

    obožavam administraciju i evidenciju❤

  • @ellentsoeu1393
    @ellentsoeu1393 5 месяцев назад

    Very helpful thank you so much

  • @beigelavender
    @beigelavender 3 года назад

    Better than the official website because it actually works !

  • @KrahyzHD
    @KrahyzHD 2 года назад +6

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

  • @MKRodz
    @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.😍

  • @ShakeelAhmed-go8nm
    @ShakeelAhmed-go8nm 2 года назад

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

  • @sambendasilva8174
    @sambendasilva8174 2 года назад

    Awasome bro 😎👌👍 Thank you🙏

  • @jacobnduya798
    @jacobnduya798 4 месяца назад

    Thank you so much this video is very helpful.

  • @ClivesEnglishCorner
    @ClivesEnglishCorner 6 месяцев назад

    Thank you this helped a lot

  • @zachbeauchamp8990
    @zachbeauchamp8990 Год назад

    Best video ive found on excell thanks for being so direct

  • @suzannekramer4134
    @suzannekramer4134 Год назад +2

    Exactly what I was looking for. Thank you!

  • @celticlofts
    @celticlofts Год назад

    Thanks a lot, it helped loads.

  • @hutchm92
    @hutchm92 10 месяцев назад

    Outstanding job! thank you!

  • @adekunlesalami3506
    @adekunlesalami3506 2 года назад

    Nice tutorial

  • @hibanour1987
    @hibanour1987 2 года назад

    You are my savior.. Thank u thaaaank you

  • @plorr2FYI
    @plorr2FYI Год назад

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

  • @adithya1577
    @adithya1577 2 года назад +1

    Thank you so much sir😀😀

  • @philiphiggins4822
    @philiphiggins4822 3 года назад

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

  • @DjofDeVos
    @DjofDeVos 2 года назад

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

  • @andycarman0129
    @andycarman0129 3 года назад +4

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

  • @mrCetus
    @mrCetus 2 года назад +1

    Bless this video, straight to the point

  • @KhalidMehmood-ey9hh
    @KhalidMehmood-ey9hh 2 года назад

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

  • @elidixon5758
    @elidixon5758 Год назад

    You got yourself a new follower

  • @shalazashim7183
    @shalazashim7183 2 года назад +1

    To the point no irrelevant stuff

  • @jelajahsebanten
    @jelajahsebanten 2 года назад

    Good tutorial my brother

  • @mariaelhaje
    @mariaelhaje 2 года назад

    Thank you, you made my frustration into a wonder!

  • @anylength2215
    @anylength2215 2 года назад

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

  • @michaelsimmons7773
    @michaelsimmons7773 Год назад

    Thanks - very helpful!

  • @gisselcalle1636
    @gisselcalle1636 Год назад

    SO HELPFUL THANK YOU

  • @alterhit
    @alterhit 4 года назад +1

    Control Semi Colon - what a winner - thanks.

  • @dariuzenn
    @dariuzenn Год назад

    Sir, you are a life saver. Thank you !

  • @a1moto283
    @a1moto283 2 года назад

    Great information - created timesheets for my department

  • @alenaatoutlemonde4036
    @alenaatoutlemonde4036 Год назад

    Huge help. Great for google sheets as well.

  • @marshallhosel1247
    @marshallhosel1247 3 года назад

    Great job

  • @AbrarManzoor
    @AbrarManzoor 3 года назад

    it saved me tons of time.

  • @thealokspoetry4596
    @thealokspoetry4596 3 года назад

    Thanks you for this

  • @hanskabdulla9116
    @hanskabdulla9116 5 лет назад +1

    thank you so useful I used today your information from Kurdistan

  • @Youstaofficial
    @Youstaofficial 3 года назад

    Thanks mate

  • @adrianchineaamoros3230
    @adrianchineaamoros3230 2 года назад

    that was awesome. Thank you so much sr!

  • @tarunkalra3924
    @tarunkalra3924 3 года назад

    Great video bud!

  • @justinryan1300
    @justinryan1300 2 года назад

    Great job, you are a star!

  • @southerncomfortuk
    @southerncomfortuk Год назад

    Brilliant thank you 🙏

  • @AnuLk-r9l
    @AnuLk-r9l Год назад

    Thank you so much❤️🥰

  • @jantendo6809
    @jantendo6809 3 года назад

    Good Tutorial Thank you

  • @motevatshots6934
    @motevatshots6934 3 года назад

    Help full vedio thank you

  • @jandekoekepan8813
    @jandekoekepan8813 2 года назад

    Nice, short and informative video!

  • @stefank4274
    @stefank4274 2 года назад +1

    THIS IS EXACTLY WHAT I WAS LOOKING FOR! THANK YOU

  • @rvr2882
    @rvr2882 3 месяца назад

    Thank you!

  • @anchit2604
    @anchit2604 2 года назад

    easily explained. thanks

  • @RAVI9700203330
    @RAVI9700203330 4 года назад +4

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

  • @smoochesluvp
    @smoochesluvp 6 месяцев назад

    2024 still needed thanks!

  • @pranavbakare8922
    @pranavbakare8922 2 года назад +2

    Easy and simpler when you explain 🔥💯

  • @rosnniejenging1910
    @rosnniejenging1910 3 года назад

    Awesome 👍 thanks for this vid

  • @FirstDan2000
    @FirstDan2000 2 года назад +2

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

    • @FirstDan2000
      @FirstDan2000 2 года назад

      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.

  • @ronitkarkera8195
    @ronitkarkera8195 2 года назад

    Thanks man.

  • @pancakewalrus99
    @pancakewalrus99 2 года назад

    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

  • @shahzadmughal7666
    @shahzadmughal7666 2 года назад

    thanks, it helps

  • @samueljh3
    @samueljh3 2 года назад

    This saved me a lot of time. Thank you!

  • @Justin-yk3ox
    @Justin-yk3ox 3 года назад +2

    this doesn't work for me. It automatically fills the same date but year advances. When I right click, the day option is not highlighted.

  • @ethiolifetips2367
    @ethiolifetips2367 Год назад

    Thank you so much

  • @nicholasrushing4156
    @nicholasrushing4156 2 года назад

    Thank you!!

  • @juanitavandeweerd699
    @juanitavandeweerd699 16 дней назад

    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?

  • @hanocky
    @hanocky 3 года назад +1

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

  • @yashsingh3913
    @yashsingh3913 3 года назад

    Very helpful

  • @hillelpaley6813
    @hillelpaley6813 2 года назад +1

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

  • @nabinshaw7980
    @nabinshaw7980 3 года назад

    Super Trick! Thank you so much!!

  • @Makstalds143
    @Makstalds143 5 месяцев назад

    THANKS!

  • @msanchez1210
    @msanchez1210 3 года назад

    Thank you 🙏🏻 saved my life

  • @JM-tf6qs
    @JM-tf6qs 2 года назад

    That was a life saver!

  • @derektravis8384
    @derektravis8384 4 года назад +1

    Thanks you.... Perfect

  • @geraldbull9272
    @geraldbull9272 2 года назад

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

  • @vasudevddn98
    @vasudevddn98 3 года назад

    thanks

  • @zanek5137
    @zanek5137 3 года назад +6

    For some reason, for me it increments the year instead of date, and I am also not able to see the fill weekday option at the bottom

    • @zanek5137
      @zanek5137 3 года назад +4

      Sort of figured it out, I just wrote it in this yyyy/mm/dd format and was able to make it work. The option even showed up at the bottom! thanks for sharing the video, super helpful!

  • @MrTounie
    @MrTounie Год назад

    Thanks 👍

  • @bionaflorbaclayon-padrigo7806
    @bionaflorbaclayon-padrigo7806 3 года назад

    Thanks😇

  • @yncomputers
    @yncomputers Год назад

    thank you kaka

  • @samuelesther5483
    @samuelesther5483 2 года назад

    thank you so much....

  • @vyvo793
    @vyvo793 3 месяца назад

    Thank you