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
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😅
नमस्कार बहुत ही बढ़िया प्रेजेंटेशन मैं कई दिनों से इस चीज को ढूंढ रहा था।आज मिल ही गया। धन्यवाद धन्यवाद धन्यवाद
@PowerExbyJitendra
Жыл бұрын
Thanks
Sir, Bahut Achchha Video banaya hai... No time waste 100% working if Following all the steps carefully.🙏
@PowerExbyJitendra
Жыл бұрын
Thanks
Very nice presentation.... everything is clear...no doubt
@PowerExbyJitendra
10 күн бұрын
Thanks a lot
Aapne jitni achchi tarah se explain Kiya main bina subscribe kiye bina nhi rah sakta...
@PowerExbyJitendra
Жыл бұрын
Apka bahut bahut dhanyavad
thanks for your help and effort ❤
Sir very useful 👍 thanks
Thank you so much sir😊
Excellent learning
Thank you & God bless💕🙏
@PowerExbyJitendra
Жыл бұрын
Thank you sir
thank you bahot achhe se samjaya
@PowerExbyJitendra
4 ай бұрын
Thanks a lot
Thank you Sir.
@PowerExbyJitendra
2 ай бұрын
Thanks
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...
Way off your teaching is wonderful Subscribed the channel & liked and gave comment
@PowerExbyJitendra
Жыл бұрын
Thank you so much 🙏
Thank you so much it's really helpful
@PowerExbyJitendra
5 ай бұрын
Thanks
Super class, Excellent زبردست
@PowerExbyJitendra
Жыл бұрын
Thanks Ilyas bhai
❤❤❤❤
Thankyou ❤❤❤❤
@PowerExbyJitendra
5 ай бұрын
Thanks🙏
Thank you bro
@PowerExbyJitendra
Жыл бұрын
You are welcome🙏
great bro❤❤
@PowerExbyJitendra
Жыл бұрын
Thanks bro
Weldone
I am your regular viewer
@PowerExbyJitendra
Жыл бұрын
Thank you so much❤
VERY GOOD SIR
@PowerExbyJitendra
Жыл бұрын
Thanks
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
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
Absolute Genius Sir You'r 🙏🙏🙏🙏🙏
@PowerExbyJitendra
Жыл бұрын
Thanks 🌹
Super
@PowerExbyJitendra
Жыл бұрын
Thanks
NOW I HAVE MADE IT
How to use calendar in excel table or form
Sir weekday function work nhi kr raha h kya krna hoga
Plz ek prog aisa ho jis mai add delete edit print amend ho
Bhaiya mai shuru se shikhana chahata hu
Sir how to insert holiday and holiday name,event name
how to pick a date from this calendar to a cell
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
How to find holidays in calender
@Altaf_Alam
Жыл бұрын
You can apply conditonal formatting...👍
Return type is not showing
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
क्या यह कैलेंडर computer पर बन जाने के बाद मोबाइल पर भी काम करेगा ?
@PowerExbyJitendra
Жыл бұрын
नहीं
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
5 ай бұрын
Hme nhi pta
Calendar formatting not work
is it possible that i want to see previous 300 hundred year ago
@PowerExbyJitendra
Жыл бұрын
Yes it is
weekday nikal ayaa sir
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 '