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

Date Functions and Formulas
1. Date Function
2. today function
3. Now Function
4. Day Month and Year Function
5. Combination of Day month and today function
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Basic Excel-Date & Time Function-DateVideo1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookupfunction#hlookupfunction#Innozant #vlookupandhlookup

[@someonefrom2002]

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

[@Learn_withkd]

Tooo good Sir .....👍👍👍

[@surajmehta9232]

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

[@Innozant]

Thanks Suraj Ji .Happy learning 🙏❤️

[@narayanbhave3020]

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

[@Innozant]

Thanks Narayan ❤️

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

[@sumansoni3223]

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

[@Innozant]

Keep learning

[@anjalitherockstar6781]

Thank you sir bahut achhe se samajh me aaya

[@Innozant]

Thanks Anjali..Keep Learning ❤️

[@Computerlearnwithraju]

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

[@Innozant]

Thanks dear

[@dipenchakma602]

very helpfull video

[@pramodchandelpkc]

Thanks for Sharing

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@RA-rh5lb]

Thank you Sir ji

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

[@DEviL-sp4uy]

Ek dm badia sir

[@Innozant]

Thanks dear

[@MrChhabraG]

Gr8 information...

[@Innozant]

Thanks Khatri Sahab

[@ChandanKumar-gp8zw]

Thanks

[@shrikantbadge3978]

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

[@Innozant]

Thanks

[@bhagyabatihansda2577]

Very nice Thanks sir

[@Innozant]

Thanks dear

[@ShubhamSharma-eb5ox]

Last part Dhamaka tha 🔥

[@Innozant]

Thanks

[@pujaverma6615]

U r too cute smart and super intelligent guy

[@Innozant]

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

[@badboy4669]

Very nice 👌👌

[@Innozant]

Thanks Samar,Happy learning

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@rajsahu1029]

Wah

[@mohitchauhan7808]

👍👍👍👍

[@gauravbhatia7987]

Good sir

[@Innozant]

👍🙏❤️

[@devendergusain8974]

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

[@Innozant]

Knowledge of excel is required..🙏

[@paramjeet975singh3]

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

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

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

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

[@syedshah4392]

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

[@paramjeet975singh3]

Good morning

[@Innozant]

Good Morning Paramjeet ji

[@tarjitmalka3978]

⭐⭐⭐⭐⭐

[@akbershah5279]

Poore week par range hai

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

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

[@muhammadkhalil5712]

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

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

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

[@bikashkumarparida7595]

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

[@Unfiltered_ind]

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

[@Innozant]

Ok.noted

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

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

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

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

[@akbershah5279]

Sir ek baat pooch ni thi

[@deovritchauhan9006]

Screen don't clear please seen by zoom

[@Innozant]

Ok...noted

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

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