🤯 This ONE Excel Formula Makes a Full Month's Calendar (No VBA!)

Поділитися
Вставка
  • Опубліковано 21 гру 2024

КОМЕНТАРІ • 23

  • @trumpexcel
    @trumpexcel  2 дні тому +2

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
    ➡Free Excel Tips Ebook - trumpexcel.com/free-ebook/
    Also, I have made all of my Excel courses available for free. You can check these out using the below links:
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course

  • @vitalieciobanu9698
    @vitalieciobanu9698 День тому +1

    👏👏👏👏 A very good example on how one can turn a complex problem into smaller ones and then go to the resolution!

  • @IvanCortinas_ES
    @IvanCortinas_ES 2 дні тому +1

    This tutorial is incredibly good. Many functions in context to create the LAMBDA function.
    Thanks for presenting it with the common mistakes that we all have, without editing the video. Great Sumit!!

  • @Joseph-xt2qg
    @Joseph-xt2qg 2 дні тому +1

    Love how you walk through the logic of all these pieces! I learned a LOT from this!

  • @elmolewis9123
    @elmolewis9123 2 дні тому +2

    Very impressive!

  • @santoshkiran5858
    @santoshkiran5858 2 дні тому +1

    Brilliant Bro 👍❤

  • @rashs9901
    @rashs9901 2 дні тому +3

    Amazing

  • @daleanderson5258
    @daleanderson5258 2 дні тому

    Wow Sumit! That is amazing. Your Excel skills are great! I will have to review the video more than once in order to see what parts I can use. However, I will use your calendar function. Thank you.

    • @trumpexcel
      @trumpexcel  2 дні тому

      Thanks Dale... Glad you found the video helpful 🙂

  • @venkatiyer7459
    @venkatiyer7459 2 дні тому

    As always you have come out with a new way .... I think I need to view the let and lambda video of yours as well .... thanks Sumitji

  • @donbogdala5428
    @donbogdala5428 15 годин тому +1

    Awesome!

  • @SyedAbdulHaseeb
    @SyedAbdulHaseeb 2 дні тому +1

    16:34 My inner self wants to shout, Boom! & You did it. Boom!

  • @Barbapoux59
    @Barbapoux59 2 дні тому +1

    Thank you for your video,
    with french microsoft office :
    for obtain the calendar with actually month :
    =Calendrier(ANNEE(AUJOURDHUI());MOIS(AUJOURDHUI()))
    bonne journée à tous ^^

  • @entrustedhub
    @entrustedhub 19 годин тому

    Great calendar! However, when I tried to highlight holidays and and today's date using conditional formatting, it did not work. Can you suggest a workaround?

  • @rajatbhardwaj4728
    @rajatbhardwaj4728 2 дні тому

    Thanks Bro

  • @gangadharbhardwaj
    @gangadharbhardwaj 2 дні тому

    very nice

  • @kylefiliput4862
    @kylefiliput4862 2 дні тому

    Is it possible to modify the calendar function to skip a row between each row of numbered dates? This would provide additional space for writing notes or other information underneath each date.

    • @vitalieciobanu9698
      @vitalieciobanu9698 День тому

      hahaha, i know what you're thinking about, i use this kind of calendar on my desk for few years now. Guess you can resolve this by making the rows with a higher height so that you end up with a bigger cell and have space for the daily to-do's/notes 😃 this is what i will do at least

  • @redhaakhund1271
    @redhaakhund1271 2 дні тому +1

    👍👍👍👍👍🙏🌹

  • @deepu_oxide
    @deepu_oxide Годину тому

    ❤🎉

  • @Colin-Fenix
    @Colin-Fenix 2 дні тому

    Love your channel, just hate the name!