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

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

[@reyal4u]

Excellent learning

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

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

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

[@mohammadilyas2260]

Super class, Excellent زبردست

[@PowerExbyJitendra]

Thanks Ilyas bhai

[@PoojaThakur-cn1mh]

Thank you so much sir😊

[@johnsonhuidrom7345]

Thank you Sir.

[@PowerExbyJitendra]

Thanks

[@gururajkulkarni3832]

Nice 👌

[@PowerExbyJitendra]

Thanks

[@raheemuddin5398]

Sir very useful 👍 thanks

[@roshanarif1564]

Sir ye calender mobile axcel me bana saktey hai?

[@PowerExbyJitendra]

Nahi ji

[@WayToWisdom15]

I am your regular viewer

[@PowerExbyJitendra]

Thank you so much❤

[@bestlearnings4265]

Weldone

[@gaukarangaurav]

Absolute Genius Sir You'r 🙏🙏🙏🙏🙏

[@PowerExbyJitendra]

Thanks 🌹

[@motivationalguru7528]

Sir weekday function work nhi kr raha h kya krna hoga

[@surenderchauhan2863]

VERY GOOD SIR

[@PowerExbyJitendra]

Thanks

[@adnanahmed8521]

Thankyou ❤❤❤❤

[@PowerExbyJitendra]

Thanks🙏

[@mr.vipgaming8289]

Thank you bro

[@PowerExbyJitendra]

You are welcome🙏

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

[@loveislife4769]

How to use calendar in excel table or form

[@reyal4u]

❤❤❤❤

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

[@naeemirfan100]

NOW I HAVE MADE IT

[@souravghosh8563]

Sir how to insert holiday and holiday name,event name

[@SatishYadav-sv9eq]

Super

[@PowerExbyJitendra]

Thanks

[@rahatahamedrafi1485]

great bro❤❤

[@PowerExbyJitendra]

Thanks bro

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

how to pick a date from this calendar to a cell

[@WayToWisdom15]

How to find holidays in calender

[@Altaf_Alam]

You can apply conditonal formatting...👍

[@kumarprakashjan]

Bhaiya mai shuru se shikhana chahata hu

[@opgamerhacker2780]

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

[@musavvaralisaiyed8119]

Tasks se connect karke bataiye

[@naseerkhan4768]

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

[@PowerExbyJitendra]

Yes it is

[@harpreetsingh9259]

Calendar formatting not work

[@nirmalyamaiti7977]

Return type is not showing

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

[@ahmedelhosomi229]

thanks for your help and effort ❤