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.co...
==============================
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/powerexby...
Contact Us:
Instagram: ...
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

[@Altaf_Alam]

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

[@PowerExbyJitendra]

Thank you so much

[@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]

D7=date of birth

[@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]

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

[@PowerExbyJitendra]

Thanks

[@mspranvlogs]

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

[@PowerExbyJitendra]

Thanks

[@poojasachdeva9623]

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

[@PowerExbyJitendra]

Thanks a lot

[@surenrk]

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

[@PowerExbyJitendra]

Apka bahut bahut dhanyavad

[@ahmedelhosomi229]

thanks for your help and effort ❤

[@johnsonhuidrom7345]

Thank you Sir.

[@PowerExbyJitendra]

Thanks

[@Matru_Chhaya]

thank you bahot achhe se samjaya

[@PowerExbyJitendra]

Thanks a lot

[@gururajkulkarni3832]

Nice 👌

[@PowerExbyJitendra]

Thanks

[@reyal4u]

Excellent learning

[@adnanahmed8521]

Thankyou ❤❤❤❤

[@PowerExbyJitendra]

Thanks🙏

[@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...

[@nitishsharma4677]

Thank you so much it's really helpful

[@PowerExbyJitendra]

Thanks

[@kristohanonkantakaron89]

Thank you & God bless💕🙏

[@PowerExbyJitendra]

Thank you sir

[@shadmanjohn123]

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

[@PowerExbyJitendra]

Thank you so much 🙏

[@raheemuddin5398]

Sir very useful 👍 thanks

[@PoojaThakur-cn1mh]

Thank you so much sir😊

[@mohammadilyas2260]

Super class, Excellent زبردست

[@PowerExbyJitendra]

Thanks Ilyas bhai

[@azad5937]

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

[@bestlearnings4265]

Weldone

[@lekhnaththapa2250]

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

[@WayToWisdom15]

I am your regular viewer

[@PowerExbyJitendra]

Thank you so much❤

[@reyal4u]

❤❤❤❤

[@mr.vipgaming8289]

Thank you bro

[@PowerExbyJitendra]

You are welcome🙏

[@surenderchauhan2863]

VERY GOOD SIR

[@PowerExbyJitendra]

Thanks

[@rahatahamedrafi1485]

great bro❤❤

[@PowerExbyJitendra]

Thanks bro

[@SatishYadav-sv9eq]

Super

[@PowerExbyJitendra]

Thanks

[@motivationalguru7528]

Sir weekday function work nhi kr raha h kya krna hoga

[@naeemirfan100]

NOW I HAVE MADE IT

[@loveislife4769]

How to use calendar in excel table or form

[@souravghosh8563]

Sir how to insert holiday and holiday name,event name

[@gaukarangaurav]

Absolute Genius Sir
You'r 🙏🙏🙏🙏🙏

[@PowerExbyJitendra]

Thanks 🌹

[@roshanarif1564]

Sir ye calender mobile axcel me bana saktey hai?

[@PowerExbyJitendra]

Nahi ji

[@WayToWisdom15]

How to find holidays in calender

[@Altaf_Alam]

You can apply conditonal formatting...👍

[@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

[@ahmedelhosomi229]

how to pick a date from this calendar to a cell

[@pankajsanwal2010]

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

[@PowerExbyJitendra]

नहीं

[@subhalaxmibindhani5445]

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]

Hme nhi pta

[@opgamerhacker2780]

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

[@kumarprakashjan]

Bhaiya mai shuru se shikhana chahata hu

[@nirmalyamaiti7977]

Return type is not showing

[@harpreetsingh9259]

Calendar formatting not work

[@motivationalguru7528]

weekday nikal ayaa sir

[@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

[@naseerkhan4768]

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

[@PowerExbyJitendra]

Yes it is

[@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]

Use this sign before first digit '