How to Create a Dynamic Calendar in Excel | No VBA

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

[@surenrk]

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

[@PowerExbyJitendra]

Apka bahut bahut dhanyavad

[@poojasachdeva9623]

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

[@PowerExbyJitendra]

Thanks a lot

[@ahmedelhosomi229]

thanks for your help and effort ❤

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

[@reyal4u]

Excellent learning

[@Matru_Chhaya]

thank you bahot achhe se samjaya

[@PowerExbyJitendra]

Thanks a lot

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

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

[@mohammadilyas2260]

Super class, Excellent زبردست

[@PowerExbyJitendra]

Thanks Ilyas bhai

[@shadmanjohn123]

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

[@PowerExbyJitendra]

Thank you so much 🙏

[@kristohanonkantakaron89]

Thank you & God bless💕🙏

[@PowerExbyJitendra]

Thank you sir

[@WayToWisdom15]

I am your regular viewer

[@PowerExbyJitendra]

Thank you so much❤

[@gururajkulkarni3832]

Nice 👌

[@PowerExbyJitendra]

Thanks

[@PoojaThakur-cn1mh]

Thank you so much sir😊

[@johnsonhuidrom7345]

Thank you Sir.

[@PowerExbyJitendra]

Thanks

[@raheemuddin5398]

Sir very useful 👍 thanks

[@bestlearnings4265]

Weldone

[@adnanahmed8521]

Thankyou ❤❤❤❤

[@PowerExbyJitendra]

Thanks🙏

[@surenderchauhan2863]

VERY GOOD SIR

[@PowerExbyJitendra]

Thanks

[@gaukarangaurav]

Absolute Genius Sir You'r 🙏🙏🙏🙏🙏

[@PowerExbyJitendra]

Thanks 🌹

[@mr.vipgaming8289]

Thank you bro

[@PowerExbyJitendra]

You are welcome🙏

[@roshanarif1564]

Sir ye calender mobile axcel me bana saktey hai?

[@PowerExbyJitendra]

Nahi ji

[@rahatahamedrafi1485]

great bro❤❤

[@PowerExbyJitendra]

Thanks bro

[@loveislife4769]

How to use calendar in excel table or form

[@motivationalguru7528]

Sir weekday function work nhi kr raha h kya krna hoga

[@SatishYadav-sv9eq]

Super

[@PowerExbyJitendra]

Thanks

[@naeemirfan100]

NOW I HAVE MADE IT

[@souravghosh8563]

Sir how to insert holiday and holiday name,event name

[@ahmedelhosomi229]

how to pick a date from this calendar to a cell

[@kumarprakashjan]

Bhaiya mai shuru se shikhana chahata hu

[@WayToWisdom15]

How to find holidays in calender

[@Altaf_Alam]

You can apply conditonal formatting...👍

[@opgamerhacker2780]

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

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

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

[@PowerExbyJitendra]

नहीं

[@musavvaralisaiyed8119]

Tasks se connect karke bataiye

[@reyal4u]

❤❤❤❤

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

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

[@nirmalyamaiti7977]

Return type is not showing

[@harpreetsingh9259]

Calendar formatting not work

[@motivationalguru7528]

weekday nikal ayaa sir

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

[@nitishsharma4677]

Thank you so much it's really helpful

[@PowerExbyJitendra]

Thanks