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
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..
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
@@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.
@@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
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.
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..🙏
Excellent sir, इस तरह से तो कभी सीखा ही नही था ये फंक्शन. नमस्ते.
Thanks Narayan ❤️
Tooo good Sir .....👍👍👍
The way you elaborate the concepts is totally ammazing and easy to understand for even a beginner.
Thanks Suraj Ji .Happy learning 🙏❤️
sir your teaching skills are amazing
and aapke 999 like the vdo pr 1000th like is mine😅
Keep learning
9:14 😆😆😆😆
Gajjb sir 😆😆😆😆👌🙏
Namstai Sir ji. Wonderful video. Happy Birthday concept today I learned new. God Bless You Sir ji🤗
Good..keep learning and share with your family, friends and others
Thank you sir bahut achhe se samajh me aaya
Thanks Anjali..Keep Learning ❤️
Sir apke padha ne ka tarika super hai sara concept samajh me aata hai
Thanks dear
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
Thanks Anurag Ji for watching some of my videos and learn new concept or recap.Happy Learning with "Dhyan lagao" 😄
TQ...SIR...🙏🙏
Ek dm badia sir
Thanks dear
Thank you Sir ji
Thanks for Sharing
We needed to breakup the date year wise and month wise. It is very beneficial.
Thanks
very helpfull video
Gr8 information...
Thanks Khatri Sahab
Last part Dhamaka tha 🔥
Thanks
Thanks
U r too cute smart and super intelligent guy
Thanks Puja ,God bless You Dear...Have a wonderful career ahead ❤️❤️👍
❤️❤️❤️❤️
Very nice 👌👌
Thanks Samar,Happy learning
Very nice Thanks sir
Thanks dear
what skills required for the learning of Power BI. Is Advance Excel and SQL is mandatory?
Knowledge of excel is required..🙏
Sir ji mis aur data analytics field main master krni hai to sir ji konse specilization se mba kru sir ji
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
Sir ji mis aur data analytics field main career bnana hai to kisi bhi specilization se mba kr skta hun
Sir time wala concept bhi kara diziye.... Jisme format 24 hours se jyada wala hota hai..
Sir mery pass error Q araha hai formula likha phir enter Kara tw #value! Ye araha hai...????
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
👍👍👍👍
Good sir
👍🙏❤️
Wah
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.
⭐⭐⭐⭐⭐
Sir apkonsa app use kerte hain video bnanay k lie
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
Hello Sir , We can use AND function here after apply if ;
If(AND(DAY(B12)=DAY(TODAY()),MONTH(B12)=MONTH(TODAY())),"hAPPY BIRTHDAY", "SORRY")
Yes Krati,We can..Good attempt dear .🙏👍❤️..Keep learning
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...??
Sir date nd time interview me puchte hin kya ya important hai sikhna
Hahahaha...Tough lag raha hai na😁
@@Innozant sir aaj fourth dy hi bounce kr ra sr pe se itni practice ke baad v
@@motivationalshayarisneha1210 recap kriye phirse
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..
Mujhe day ki range main se specific day par text show karna hai apni marzi ka to kese hoga please bata den
@innozantofficial telegram id par share kiya kren query
Good morning
Good Morning Paramjeet ji
Respected sir how to google translate a cell referrance with now function. Thank you sir
Thanks Sudip
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
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 🙏🙏🙏🙏
Poore week par range hai
=DATE(YEAR(B5),MONTH(B5)-1,DAY(B5))
Sir ek video sumifs with date function pr create kijye please sir....
Ok.noted
=IF(AND(DAY(H9)=DAY(TODAY()),MONTH(H9)=MONTH(TODAY())),"today is my birth day","no birthday") is this right sir?
How I Show, birth date(YYYY-MM-DD) or how to calculate remaing days
Using datedif function dear..kindky watch the video for the same
@@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.
why we put () after=Today OR after =Now ? functions
Parenthesis is used the take parameters inside formula dear
@@Innozant thanks sir
@@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
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
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.
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..🙏
@@Innozant thanks sir
Sir ek baat pooch ni thi
Screen don't clear please seen by zoom
Ok...noted
Please reply sir
Unko aaj hi Paida kr dete h ky dikkat hai 😂😂😂
Hahahaha 😂
Bikul sir Dhyan bahut zaruri he