How to Create a Dynamic Calendar in Excel | No VBA

How to Create a Dynamic Calendar in Excel | No VBA
Learn how to create a dynamic calendar using excel basic functions. No advanced function and no macro is required. If you just started learning Excel, you can still create it.
So watch the video and if you find it valuable please subscribe our channel:
/ powerexbyjitendra
And if you want to download our file, click on below link:
==============================
docs.google.com/spreadsheets/...
==============================
Related Videos Playlist:
Custom Number Formatting Tricks
• Custom Number Formatting
-----------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
5. Data Entry Form
• Data Entry Forms
6. Custom Number Formatting Tricks
• Custom Number Formatting
7. Recent Uploads
• Recent Uploaded Videos
--------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#dynamicecalendar
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Thanks

Пікірлер: 70

  • @Altaf_Alam
    @Altaf_Alam Жыл бұрын

    Aap Bahot neat and clean video banate hai sir ❤️....saath mein voice Bhi clear

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thank you so much

  • @Altaf_Alam

    @Altaf_Alam

    Жыл бұрын

    @@PowerExbyJitendra sir 1 question tha....agar apna birthday date ko highlight karna ho har year ka uss month mein toh kounsa formula lagega conditional formatting mein?

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    D7=date of birth

  • @Altaf_Alam

    @Altaf_Alam

    Жыл бұрын

    @@PowerExbyJitendra sir aise karne se bas usi year ka highlight hoga jo mai type karuga.....mai chahta hu kisi bhi year mein jaye toh date of birth highlighted ho😅

  • @prakashrewale9776
    @prakashrewale9776 Жыл бұрын

    नमस्कार बहुत ही बढ़िया प्रेजेंटेशन मैं कई दिनों से इस चीज को ढूंढ रहा था।आज मिल ही गया। धन्यवाद धन्यवाद धन्यवाद

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @mspranvlogs
    @mspranvlogs Жыл бұрын

    Sir, Bahut Achchha Video banaya hai... No time waste 100% working if Following all the steps carefully.🙏

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @poojasachdeva9623
    @poojasachdeva962310 күн бұрын

    Very nice presentation.... everything is clear...no doubt

  • @PowerExbyJitendra

    @PowerExbyJitendra

    10 күн бұрын

    Thanks a lot

  • @surenrk
    @surenrk Жыл бұрын

    Aapne jitni achchi tarah se explain Kiya main bina subscribe kiye bina nhi rah sakta...

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Apka bahut bahut dhanyavad

  • @ahmedelhosomi229
    @ahmedelhosomi22910 ай бұрын

    thanks for your help and effort ❤

  • @raheemuddin5398
    @raheemuddin5398 Жыл бұрын

    Sir very useful 👍 thanks

  • @PoojaThakur-cn1mh
    @PoojaThakur-cn1mh Жыл бұрын

    Thank you so much sir😊

  • @reyal4u
    @reyal4u3 ай бұрын

    Excellent learning

  • @kristohanonkantakaron89
    @kristohanonkantakaron89 Жыл бұрын

    Thank you & God bless💕🙏

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thank you sir

  • @Matru_Chhaya
    @Matru_Chhaya4 ай бұрын

    thank you bahot achhe se samjaya

  • @PowerExbyJitendra

    @PowerExbyJitendra

    4 ай бұрын

    Thanks a lot

  • @johnsonhuidrom7345
    @johnsonhuidrom73452 ай бұрын

    Thank you Sir.

  • @PowerExbyJitendra

    @PowerExbyJitendra

    2 ай бұрын

    Thanks

  • @rajeevmadaan2483
    @rajeevmadaan2483 Жыл бұрын

    Sir, Liked your dynamic calendar very much. Can you also please guide in furtherance to it as to how we can add "Dynamic Task List" related to this calender...

  • @shadmanjohn123
    @shadmanjohn123 Жыл бұрын

    Way off your teaching is wonderful Subscribed the channel & liked and gave comment

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thank you so much 🙏

  • @nitishsharma4677
    @nitishsharma46775 ай бұрын

    Thank you so much it's really helpful

  • @PowerExbyJitendra

    @PowerExbyJitendra

    5 ай бұрын

    Thanks

  • @mohammadilyas2260
    @mohammadilyas2260 Жыл бұрын

    Super class, Excellent زبردست

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks Ilyas bhai

  • @reyal4u
    @reyal4u3 ай бұрын

    ❤❤❤❤

  • @adnanahmed8521
    @adnanahmed85215 ай бұрын

    Thankyou ❤❤❤❤

  • @PowerExbyJitendra

    @PowerExbyJitendra

    5 ай бұрын

    Thanks🙏

  • @mr.vipgaming8289
    @mr.vipgaming8289 Жыл бұрын

    Thank you bro

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    You are welcome🙏

  • @rahatahamedrafi1485
    @rahatahamedrafi1485 Жыл бұрын

    great bro❤❤

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks bro

  • @bestlearnings4265
    @bestlearnings42659 ай бұрын

    Weldone

  • @mustaqahmedattar8462
    @mustaqahmedattar8462 Жыл бұрын

    I am your regular viewer

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thank you so much❤

  • @surenderchauhan2863
    @surenderchauhan2863 Жыл бұрын

    VERY GOOD SIR

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @azad5937
    @azad59372 ай бұрын

    Hello sir,, Thank you for this video. Q. if i don’t want to show the next month dates on my current month, so which formula i can use. 13:25

  • @lekhnaththapa2250
    @lekhnaththapa22507 ай бұрын

    i am using excel 2007 & could not create dynamic calender with year 2024, sep following your video. Sunday to monday weekday i used 1 as return type 1 displays 31 for the date 1/01/2024

  • @gaukarangaurav
    @gaukarangaurav Жыл бұрын

    Absolute Genius Sir You'r 🙏🙏🙏🙏🙏

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks 🌹

  • @SatishYadav-sv9eq
    @SatishYadav-sv9eq Жыл бұрын

    Super

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Thanks

  • @naeemirfan100
    @naeemirfan100 Жыл бұрын

    NOW I HAVE MADE IT

  • @loveislife4769
    @loveislife47694 ай бұрын

    How to use calendar in excel table or form

  • @motivationalguru7528
    @motivationalguru7528Ай бұрын

    Sir weekday function work nhi kr raha h kya krna hoga

  • @opgamerhacker2780
    @opgamerhacker2780 Жыл бұрын

    Plz ek prog aisa ho jis mai add delete edit print amend ho

  • @kumarprakashjan
    @kumarprakashjan Жыл бұрын

    Bhaiya mai shuru se shikhana chahata hu

  • @souravghosh8563
    @souravghosh85635 ай бұрын

    Sir how to insert holiday and holiday name,event name

  • @ahmedelhosomi229
    @ahmedelhosomi22910 ай бұрын

    how to pick a date from this calendar to a cell

  • @ExcelAndTallyMaster
    @ExcelAndTallyMaster Жыл бұрын

    Hii can u please explain why u took return type 3 in weekday Formula why u didn't take 1 or any other number in return type please please explain

  • @mustaqahmedattar8462
    @mustaqahmedattar8462 Жыл бұрын

    How to find holidays in calender

  • @Altaf_Alam

    @Altaf_Alam

    Жыл бұрын

    You can apply conditonal formatting...👍

  • @nirmalyamaiti7977
    @nirmalyamaiti797711 ай бұрын

    Return type is not showing

  • @rajeevmadaan2483
    @rajeevmadaan2483 Жыл бұрын

    I think you select the undernoted comments as per your own set of whims &fancies.. Kindly do'n mind. I was waiting for your respond back here as you had responded to some one else's comment later on. Any ways

  • @pankajsanwal2010
    @pankajsanwal2010 Жыл бұрын

    क्या यह कैलेंडर computer पर बन जाने के बाद मोबाइल पर भी काम करेगा ?

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    नहीं

  • @subhalaxmibindhani5445
    @subhalaxmibindhani544510 ай бұрын

    Hello sir meri date color hide nahi ho raha hai. Bar bar karneki bad vhi Monday date column chod ke all date color grey ho jata hai. Pl aap conditional formatting ka formula thoda type karke send karege.

  • @VishalKumar-tn2ft

    @VishalKumar-tn2ft

    5 ай бұрын

    Hme nhi pta

  • @harpreetsingh9259
    @harpreetsingh9259 Жыл бұрын

    Calendar formatting not work

  • @naseerkhan4768
    @naseerkhan4768 Жыл бұрын

    is it possible that i want to see previous 300 hundred year ago

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Yes it is

  • @motivationalguru7528
    @motivationalguru7528Ай бұрын

    weekday nikal ayaa sir

  • @naseerkhan4768
    @naseerkhan4768 Жыл бұрын

    SIR VERY NICE PLEASE SOLVE MY PROBLEMS IF I ENTER ABOVE 15 DIGIT IN EXCEL THEN EXCEL SHOW ABOVE 15 DIGIT AS 000 FOR EXAMPLE 1234567891234560000

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    Use this sign before first digit '

Келесі