Date Functions & Formulas Part 1 | How to combine Day Month and today function

[@someonefrom2002]

9:14 😆😆😆😆 Gajjb sir 😆😆😆😆👌🙏

[@sumansoni3223]

sir your teaching skills are amazing and aapke 999 like the vdo pr 1000th like is mine😅

[@Innozant]

Keep learning

[@Learn_withkd]

Tooo good Sir .....👍👍👍

[@narayanbhave3020]

Excellent sir, इस तरह से तो कभी सीखा ही नही था ये फंक्शन. नमस्ते.

[@Innozant]

Thanks Narayan ❤️

[@surajmehta9232]

The way you elaborate the concepts is totally ammazing and easy to understand for even a beginner.

[@Innozant]

Thanks Suraj Ji .Happy learning 🙏❤️

[@sandeepaswal8944]

Namstai Sir ji. Wonderful video. Happy Birthday concept today I learned new. God Bless You Sir ji🤗

[@Innozant]

Good..keep learning and share with your family, friends and others

[@Computerlearnwithraju]

Sir apke padha ne ka tarika super hai sara concept samajh me aata hai

[@Innozant]

Thanks dear

[@anjalitherockstar6781]

Thank you sir bahut achhe se samajh me aaya

[@Innozant]

Thanks Anjali..Keep Learning ❤️

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@RA-rh5lb]

Thank you Sir ji

[@ShubhamSharma-eb5ox]

Last part Dhamaka tha 🔥

[@Innozant]

Thanks

[@anuragupadhyay8402]

Thanks to you!! I do use this function atleast 10 times in a day..And sometime I remember your word "Dhyan lagao", whenever I stuck somewhere. Thanks once again

[@Innozant]

Thanks Anurag Ji for watching some of my videos and learn new concept or recap.Happy Learning with "Dhyan lagao" 😄

[@pramodchandelpkc]

Thanks for Sharing

[@shrikantbadge3978]

We needed to breakup the date year wise and month wise. It is very beneficial.

[@Innozant]

Thanks

[@pujaverma6615]

U r too cute smart and super intelligent guy

[@Innozant]

Thanks Puja ,God bless You Dear...Have a wonderful career ahead ❤️❤️👍

[@dipenchakma602]

very helpfull video

[@DEviL-sp4uy]

Ek dm badia sir

[@Innozant]

Thanks dear

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@MrChhabraG]

Gr8 information...

[@Innozant]

Thanks Khatri Sahab

[@badboy4669]

Very nice 👌👌

[@Innozant]

Thanks Samar,Happy learning

[@ChandanKumar-gp8zw]

Thanks

[@bhagyabatihansda2577]

Very nice Thanks sir

[@Innozant]

Thanks dear

[@zannesarahamed8776]

Very nice sir 👌 Sir, mujhe count karna hai ki Ek hi formula main P + CR with date &month as CR 27/10. How to count in one column. Please explain sir

[@paramjeet975singh3]

Sir time wala concept bhi kara diziye.... Jisme format 24 hours se jyada wala hota hai..

[@devendergusain8974]

what skills required for the learning of Power BI. Is Advance Excel and SQL is mandatory?

[@Innozant]

Knowledge of excel is required..🙏

[@sahilkumar4100]

Sir ji mis aur data analytics field main master krni hai to sir ji konse specilization se mba kru sir ji

[@Innozant]

Wo to apne interest ke hisab se karen..apka kis field me interest hai aur acha skills upgrade krenge to ache profile par switch kar jayenge

[@sahilkumar4100]

Sir ji mis aur data analytics field main career bnana hai to kisi bhi specilization se mba kr skta hun

[@muhammadkhalil5712]

Sir mery pass error Q araha hai formula likha phir enter Kara tw #value! Ye araha hai...????

[@mohitchauhan7808]

👍👍👍👍

[@motivationalshayarisneha1210]

Sir date nd time interview me puchte hin kya ya important hai sikhna

[@Innozant]

Hahahaha...Tough lag raha hai na😁

[@motivationalshayarisneha1210]

@@Innozant sir aaj fourth dy hi bounce kr ra sr pe se itni practice ke baad v

[@Innozant]

@@motivationalshayarisneha1210 recap kriye phirse

[@kratikhandelwal3511]

Hello Sir , We can use AND function here after apply if ; If(AND(DAY(B12)=DAY(TODAY()),MONTH(B12)=MONTH(TODAY())),"hAPPY BIRTHDAY", "SORRY")

[@Innozant]

Yes Krati,We can..Good attempt dear .🙏👍❤️..Keep learning

[@muhammadkhalil5712]

Sir mery pas error araha hai apka formula bhi apply kara or sir ka formula bhi ye error araha hai #value! What should I do...??

[@aadilfarooque8000]

Sir apkonsa app use kerte hain video bnanay k lie

[@rajsahu1029]

Wah

[@abhaykumar3628]

Hello Sir, How to extract Das from Surbhi Aman Das Vats using MID and FIND function? We can extract Aman from Surbhi Aman Vats using MID and FIND.

[@gauravbhatia7987]

Good sir

[@Innozant]

👍🙏❤️

[@paramjeet975singh3]

Good morning

[@Innozant]

Good Morning Paramjeet ji

[@MohanKumar-uk1gj]

Sirji today function to current date yani ki system date dikha dega yeh to samajgaya per mere ko aaj ka actual date chahiye to kaunsi function istumal karu..

[@rajatchaurasia9973]

Sir I sended you data on your mail id to take out difference between two date & time if time is given in UTC time zone

[@syedshah4392]

=DATE(YEAR(B5),MONTH(B5)-1,DAY(B5))

[@tarjitmalka3978]

⭐⭐⭐⭐⭐

[@akbershah5279]

Mujhe day ki range main se specific day par text show karna hai apni marzi ka to kese hoga please bata den

[@Innozant]

@innozantofficial telegram id par share kiya kren query

[@naeemahmedpirzada9255]

Sir buhat jaga p year 31 june ko close hota hy us ko likhte hain hum for example year 2020-21 es main hamen kuch function bataen Thanks 🙏🙏🙏🙏

[@drsudipkundu]

Respected sir how to google translate a cell referrance with now function. Thank you sir

[@Innozant]

Thanks Sudip

[@drsudipkundu]

Brief drescription of my problem: If a report is generated depending on time based criteria , after that the generated report can not be transleted to bengali language. Showing the error message " referance cell should not contain now(), rand() etc ...". Thank you sir

[@akbershah5279]

Poore week par range hai

[@Unfiltered_ind]

Sir ek video sumifs with date function pr create kijye please sir....

[@Innozant]

Ok.noted

[@bikashkumarparida7595]

=IF(AND(DAY(H9)=DAY(TODAY()),MONTH(H9)=MONTH(TODAY())),"today is my birth day","no birthday") is this right sir?

[@santoshkumaryadav8864]

why we put () after=Today OR after =Now ? functions

[@Innozant]

Parenthesis is used the take parameters inside formula dear

[@santoshkumaryadav8864]

@@Innozant thanks sir

[@santoshkumaryadav8864]

@@Innozant I m downloading your videos one by one, after watching those ...Also downloading practice sheets. Thanks fir providing valuable tutorials....I was trying for many years to learn having lot of excel text with me but it is difficult to go by theory . Regards

[@santoshkumaryadav8864]

Where we use big, middle and small bracket in formulae?....Rather making formula on excel is base don what concept? Plz , if you can make it clear

[@deepakchauhan4974]

agar koi bada DOB ka data hai or hame nikalna hia ki kisi ka happy birhtday kab hai to apne bataya "=IF(DAY(J15)&MONTH(J15)=DAY(TODAY())&MONTH(TODAY()),"Happy Birthday Deepak Chauhan","no status")" long formulae use karenge , lekin jab maine "=IF(TODAY()=J15,"happy Birthday","No status") use kiya to bhi aa gya , fir itna lamba use kyu kiye sir, Please advise me if any drawback in this or advise accordingly.

[@Innozant]

Dear Deepak bday wish kya sirf date se krnege ya nonth bhi😀aap khud sochiye ye function kya krega..ye to ek cnadidate ko har mahine wish karega ..man lo usk bday 15 oct ko aata h..to ye to harb15 ko wish krega..🙏

[@deepakchauhan4974]

@@Innozant thanks sir

[@iSonuGautam]

How I Show, birth date(YYYY-MM-DD) or how to calculate remaing days

[@Innozant]

Using datedif function dear..kindky watch the video for the same

[@iSonuGautam]

@@Innozant Thanks I can see (YYYY-MM-DD) but, How can I pass the msg HBD if the condition true, if the condition false pass the msg you have like you have 11 months and 20 days remaining, something like this.

[@akbershah5279]

Sir ek baat pooch ni thi

[@deovritchauhan9006]

Screen don't clear please seen by zoom

[@Innozant]

Ok...noted

[@abhaykumar3628]

Please reply sir

[@yogeshrao5924]

Bikul sir Dhyan bahut zaruri he

[@ShabbirKhan-pq8iq]

Unko aaj hi Paida kr dete h ky dikkat hai 😂😂😂

[@Innozant]

Hahahaha 😂