Тёмный

How to Create a Dynamic Calendar in Excel | No VBA 

PowerEx by Jitendra
Подписаться 113 тыс.
Просмотров 73 тыс.
50% 1

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

Опубликовано:

 

25 авг 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 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
@surenrk
@surenrk Год назад
Aapne jitni achchi tarah se explain Kiya main bina subscribe kiye bina nhi rah sakta...
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Apka bahut bahut dhanyavad
@poojasachdeva9623
@poojasachdeva9623 Месяц назад
Very nice presentation.... everything is clear...no doubt
@PowerExbyJitendra
@PowerExbyJitendra Месяц назад
Thanks a lot
@ahmedelhosomi229
@ahmedelhosomi229 11 месяцев назад
thanks for your help and effort ❤
@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...
@lekhnaththapa2250
@lekhnaththapa2250 8 месяцев назад
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
@raheemuddin5398
@raheemuddin5398 Год назад
Sir very useful 👍 thanks
@reyal4u
@reyal4u 4 месяца назад
Excellent learning
@PoojaThakur-cn1mh
@PoojaThakur-cn1mh Год назад
Thank you so much sir😊
@shadmanjohn123
@shadmanjohn123 Год назад
Way off your teaching is wonderful Subscribed the channel & liked and gave comment
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thank you so much 🙏
@kristohanonkantakaron89
@kristohanonkantakaron89 Год назад
Thank you & God bless💕🙏
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thank you sir
@Matru_Chhaya
@Matru_Chhaya 5 месяцев назад
thank you bahot achhe se samjaya
@PowerExbyJitendra
@PowerExbyJitendra 5 месяцев назад
Thanks a lot
@nitishsharma4677
@nitishsharma4677 6 месяцев назад
Thank you so much it's really helpful
@PowerExbyJitendra
@PowerExbyJitendra 6 месяцев назад
Thanks
@azad5937
@azad5937 3 месяца назад
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
@johnsonhuidrom7345
@johnsonhuidrom7345 3 месяца назад
Thank you Sir.
@PowerExbyJitendra
@PowerExbyJitendra 3 месяца назад
Thanks
@mohammadilyas2260
@mohammadilyas2260 Год назад
Super class, Excellent زبردست
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thanks Ilyas bhai
@bestlearnings4265
@bestlearnings4265 10 месяцев назад
Weldone
@rahatahamedrafi1485
@rahatahamedrafi1485 Год назад
great bro❤❤
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thanks bro
@adnanahmed8521
@adnanahmed8521 6 месяцев назад
Thankyou ❤❤❤❤
@PowerExbyJitendra
@PowerExbyJitendra 6 месяцев назад
Thanks🙏
@mr.vipgaming8289
@mr.vipgaming8289 Год назад
Thank you bro
@PowerExbyJitendra
@PowerExbyJitendra Год назад
You are welcome🙏
@Psychoche15
@Psychoche15 Год назад
I am your regular viewer
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thank you so much❤
@surenderchauhan2863
@surenderchauhan2863 Год назад
VERY GOOD SIR
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thanks
@reyal4u
@reyal4u 4 месяца назад
❤❤❤❤
@SatishYadav-sv9eq
@SatishYadav-sv9eq Год назад
Super
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thanks
@motivationalguru7528
@motivationalguru7528 2 месяца назад
Sir weekday function work nhi kr raha h kya krna hoga
@loveislife4769
@loveislife4769 5 месяцев назад
How to use calendar in excel table or form
@gaukarangaurav
@gaukarangaurav Год назад
Absolute Genius Sir You'r 🙏🙏🙏🙏🙏
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Thanks 🌹
@naeemirfan100
@naeemirfan100 Год назад
NOW I HAVE MADE IT
@souravghosh8563
@souravghosh8563 5 месяцев назад
Sir how to insert holiday and holiday name,event name
@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
@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
@ahmedelhosomi229
@ahmedelhosomi229 11 месяцев назад
how to pick a date from this calendar to a cell
@opgamerhacker2780
@opgamerhacker2780 Год назад
Plz ek prog aisa ho jis mai add delete edit print amend ho
@Psychoche15
@Psychoche15 Год назад
How to find holidays in calender
@Altaf_Alam
@Altaf_Alam Год назад
You can apply conditonal formatting...👍
@kumarprakashjan
@kumarprakashjan Год назад
Bhaiya mai shuru se shikhana chahata hu
@nirmalyamaiti7977
@nirmalyamaiti7977 Год назад
Return type is not showing
@harpreetsingh9259
@harpreetsingh9259 Год назад
Calendar formatting not work
@subhalaxmibindhani5445
@subhalaxmibindhani5445 11 месяцев назад
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 6 месяцев назад
Hme nhi pta
@pankajsanwal2010
@pankajsanwal2010 Год назад
क्या यह कैलेंडर computer पर बन जाने के बाद मोबाइल पर भी काम करेगा ?
@PowerExbyJitendra
@PowerExbyJitendra Год назад
नहीं
@naseerkhan4768
@naseerkhan4768 Год назад
is it possible that i want to see previous 300 hundred year ago
@PowerExbyJitendra
@PowerExbyJitendra Год назад
Yes it is
@motivationalguru7528
@motivationalguru7528 2 месяца назад
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 '
Далее
Fail pass formula in excel #excel
1:00
Просмотров 634 тыс.
Make Calendar in Excel 2019
10:02
Просмотров 198 тыс.