Excel Date Functions : Date Value , Weeknum , Days , Days360

[@satyawankumar8722]

आप जितने अच्छे से समझाते हैं। उतने अच्छे से तो वो भी नही समझाते जो 5 महीने के 25000 charge करते हैं। धन्यवाद आपका

[@Innozant]

Thanks Satyawant ji.Happy learning ❤️

[@brittokhan5278]

right

[@rudrakantjha2712]

You are amazing teacher ❤🌿 and the best part is you enjoy teaching.

[@Innozant]

Thanks..Keep learning dear

[@soniasandhu4944]

Sir you deserve much more like. Thanks sir

[@Innozant]

Thanks Sonia for your valuable feedback.. Really means a lot to me.Happy learning dear.. Recommend you think start your Learning journey from Playlist Basic Excel followed with wih advanced and After completion of course you must attempt Interview Cracker and Live Interview series❤️❤️❤️🙏🙏🙏

[@vinaychauhan5734]

Boss ur video helped me alot.. God bless u

[@Innozant]

Thanks Vinay👍❤️

[@msexcelgooglesheet374]

You are Good at teaching sir ji , Aap Hamesha Isi Tarha hume padate rahe .............

[@Innozant]

Thanks Dear,Good morning,Have a nice day. Sure humesha video aata rhega dear

[@msexcelgooglesheet374]

@@Innozant Welcome Sir ji ...🙏

[@iamsainipawan]

Sir your Teaching method is out of box har ek video mein Kuch na kuch nahi chez sikhne ko milti hai itna koi Nahin sikhata Jo aap sikha rehe ho humara ❤️ aur support hamesha Aapke sath hai 🙏

[@Innozant]

Thanks Saini Sahab .God bless you

[@sandeepaswal8944]

Sir so knowledgeable video. Aaj new method shikha. Maja aagay esh tutorial ko shikhkar. Bahut hi simple aur achai Tarikai sai samjya aapnai. Thank you so much sir ji.God bless you.

[@Innozant]

Thanks ..ab next video wo bhi aaj hi @10pm..Aapke liye.Must watch

[@mayadharsahoo8854]

Guruji pranam. From other views u teaches well but u teach me well. Plz I request you . .

[@tejpalsain1507]

नमस्कार सर। आज मेने नया फंक्शन सीखा। WeekNum का। आपका बहुत बहुत आभार

[@Innozant]

Good

[@Mrsudeshazad]

Thank you so much sir🙏❤️❤️❤️

[@Innozant]

Thanks Sudesh ji ❤️

[@adarshkhurana7083]

❤❤Your all vid are precious sir..

[@Innozant]

Thanks Adarsh Ji

[@shivprasadmishra268]

I like your creativity thoughts of teaching

[@Innozant]

Thanks Shiv

[@AllahDitta-gp5lt]

جزاکم اللّٰہ خیرا کثیرا کثیرا سر

[@RobinSingh-si5ye]

Love u respect u sir❤️

[@rahulkashyap2704]

Amazing guru ji ❤️❣️

[@RA-rh5lb]

Thank you Sir ji.

[@multipleknowledgetopics3417]

amazing explanation

[@Innozant]

Thanks dear.keep learning

[@hemantgusain1260]

Thanks you sir for explaining new new formula with easy example.

[@Innozant]

Thanks Hemant Ji...Next video..going to upload soon..aaj hi

[@NomanAli-rl2nr]

Very respectable sir❤❤

[@Innozant]

Thanks..Keep Learning

[@dhakafady774]

Thanks a lot

[@kirtisharma2373]

now it is clear.....😊

[@Innozant]

Thanks Kriti

[@AftabAhmed-uw4ki]

Very nice explanation 💓💓💓💓💓💓💓💓🇵🇰💕💕💕💕

[@AftabAhmed-uw4ki]

Sir sb ko reply krta hn mujhe nhi krta ho sir plz ku

[@AllahDitta-gp5lt]

Thanks u dear sir

[@chetnakikan3721]

Superb sir 👍👍

[@Innozant]

Thanks Chetna..Happy leay dear..God Bless You

[@bhoopendraraghav9781]

Very nice video

[@Innozant]

Thanks Bhoopendra Ji.

[@Pandimoori_krish]

HI your excel vedios are superb way of explanation super could you please tell me formula for weeknumber for given date range in a month ex: 23/05/2022 to 27/05/2022

[@shivprasadmishra268]

Please upload video related Excel and Programming Conversation

[@satishojha6240]

Very nice sir Good night

[@Innozant]

Abhi Good Night Nahin Satish Ji,Ek Video aaj aur aane wala ha @10pm.

[@satishojha6240]

@@Innozant ohh sorry sir galti se phele wala video ko comments kar diya

[@gauravbhatia7987]

Thnq sir

[@Innozant]

👍❤️

[@sakshijangra313]

Wow sir 🙏

[@Innozant]

❤️👍

[@hemendrakumarvarshney8825]

Currently we face the issue of different date format like dd-mm-yyyy , mm-dd-yyyy etc. plz make a video on conversion of that also

[@Innozant]

Ok..noted 👍

[@998bro9]

how to calculate weeknumber if my yr starts from 01-04-2023???

[@battlefansshorts8941]

Thank q sir

[@Innozant]

❤️🙏

[@sunilkumarak5793]

Sir, can we bold a cell value, or part thereof after joining two or more cell values by concatenate/ text join..?

[@abdullahskillshub7322]

i am also in need of this solution. if you have got it, kindly share.

[@tattwadarshijnanaprakash8848]

Sir if I count my week number as per financial year then what should I do to get right week number

[@amitpyasi2819]

Sir what is according system

[@DEviL-sp4uy]

Amazing video sir Sir agar pata Karna ho ye is year Ka Konsa week chal rha h to Uske liye Konsa formula use hoga sir ????

[@Innozant]

Weeknum()

[@pareshparikh7944]

Nice

[@Innozant]

Thanks Paresh ji...

[@savitabirje4953]

Sir good afternoon, I have a data there add received data and time if i used there formula for seprate data and time. I got there some data and time but some data and time again i got error #value! Sir how to sort out this error ??

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@fermion4945]

Hello sir ,datvalue function VALUE! error kyu dikha rha hai ?

[@paramjeet975singh3]

thanx sir,,,,,kab tk aayga sir

[@knramesh8417]

Sir then what is the difference between Value and Datevalue function

[@01chakri]

Sir please explain how to go head

[@mohitchauhan7808]

👍👍👍👍

[@ManjeetSingh-th4fu]

Sir, weeknum function m return type ka option mere laptop m show kyu nhi ho raha h? Plz

[@nksahu7575]

I want to change day in year ,month, day I apply dateedif formula But not find right value If I change 365 day in year then show 11 m and 30 day How solve it

[@moonmoonsarkar1766]

How to write feb wk 3 in excel

[@pritamdey4556]

23-12-2021 23rd Day of December'2021 24-12-2021 Sir Iss date ko, aise text format mey kaise kare??

[@rakheejain9894]

Sir, how can i download practice data file

[@Innozant]

Hi Rakhee .Kindly find Master Assignment Folder link available ik Video description..You may download from there..if any issue while downloading.lwt me knw

[@suhaimiabdazais]

Let say 1/1/2022 and 2/1/2022 is Sat & Sun by auto is week 1.. how to formulate 3/1/2022 as a week 1? and how to format as WEEK 01, WEEK 02 ...etc

[@01chakri]

If change fy weeknnum starting April to march change to dynamic way pls share

[@Innozant]

Which kinds of prob you are facing while trying to make it dynamic?

[@danveerdebpratim6294]

Jinhone fee liya h 30k unko itna pta hi nhi h mai apse Sikh k unko bta k ata hun roj

[@Innozant]

Thanks dear.Keep Learning

[@KunalSingh-oy1ny]

Sir days function count no. of days between two dates but what if i don`t want to count saturday & sunday between those two dates.

[@Innozant]

you newd to customize your formula to skip sat and sun

[@mayadharsahoo8854]

Till yet I can not understand. lz slow method sir plz in slow method😂

[@sadhnaautomobiles614]

Yogesh

[@deepakchauhan4974]

sir , mera value aa rha hai , - concept se or days se bhi

[@Innozant]

good

[@RobinSingh-si5ye]

Sir mujhe apke kesa bnna h

[@roshankumarsinghmirz]

Agar mai 10 feb ko week 1 krna chahu to kese karenge

[@ishutiwari5567]

sir, kyi jgh pe days function pe jo value ari h vo days360(false) function se nhi ari.jbki dono same hone chaiye. aur kyi jgh pe days360 ke true and false dono criteria pe same value ari h.mene 20-5-2019 and 01-07-2019 dates pe try kiye ye function. esa kyo ?

[@Innozant]

Days360 tabhi use krenfy Ishu yadi humara accounting system 360 day year Hoga.. Us method to sane humare jaisa hai but European method me alag Hoga .. Ye bhi bus difference hi nikalega Jaise humara days krta hai 2 date ki bichka diff

[@ishutiwari5567]

@@Innozant sir, apki bat to theek h ki europen countries ke liye h ye function but 20-5-2019 se 1-7-2019 tk ki dates ka difference days360 function ke true and false dono criteria pe same hi bta rha h (value is 41) jbki apki video me different values ari thi.apne hi video me bola tha ki false criteria dene pe days function ki trh kaam krega aur true criteria dene pe europen countries ke liye kaam krega.to values dono criteria me different ani chaiye. mere case me same kyo ari h values h. me sirf days360 ke true and false criteria ki bat krri hu filhal sir.

[@Innozant]

Haan phir days360 yadi use Kar rahe Hain aur us method hi liya hai to days Function Jaise hi 2 date ke bich Ka difference dikhana chaiye Ishu..alag to nhi aana chaiye ap 1st Dec to 31 at Dec leke dekhna 30 as Raha hai ki nhi

[@ishutiwari5567]

@@Innozant sir 1dec to 31st dec ka 30 ara h but ap ek bar meri dates leke dekho 20-5-2019 to 1-7-2019 isme days360(true) and days360(false) dono me 41 kyo ari h value jbki different honi chahiye jese apke 1st dec to 31st dec me days360(false) ki value 30 h but days360(true) ki value 29 h

[@Innozant]

Ok..Let me check.. Good Morning.Hv A great day❤️🙏

[@naeemkhan-tm9hx]

Dashboard wala video kab ayega sir...8 videos k bad aya nhi ab

[@Innozant]

Naeem saha harek playlist ke liye video ban rahe hain..uska bhi phir hoga upload by next week.

[@arunkumarsahu4938]

Sir value and date value me difference kya hai

[@Innozant]

dono me difference hai dear... value kisi bhi text ko value me convert krta hai Jacki datevalue (wo date jo ki text ke form me hai use value me convert krta hai)

[@arunkumarsahu4938]

@@Innozant sir apke video dekhne se pehele date text ko value me convert kiya it's work same

[@gaureeshankarsharma2930]

Sir good morning sir , Sir I am Working in agriculture firm , sir in my office every month new joing hota ha to es condition me jo employee jis month me joining hua ha ,aur jis date se join hua uska actual working days nikalna padta ha sir , ji ki maximum perticular month me total days se jyada nhi hona chaiye .please make a vedeo sir , old person ko bhi as per authorised approval but not more than total month daya sir please make sir

[@rajnishranjandubey1940]

Sir excel 2007 hai mera

[@rajnishranjandubey1940]

Isme same problem aa rhi hai 4 jan week 2 me aa ja rha

[@IrfanAnsari-nz1fu]

mujhe vlookup formula mein date and day ke hisab se lookup lagana hai kaise lagayenge . jaise mere pass ek mahine ka data hai aur usme kisi bhi date ka lookup data uthana hai kaise hoga wo mujhe share kijiye ya phir video banayiye aap . bahut jaruri hai mujhe

[@Innozant]

Interview cracker me kraya hai ye ques

[@IrfanAnsari-nz1fu]

@@Innozant yes

[@surajsawant.2220]

Sirji Jara zoom kam kiya karo screen. bada bada zoom its looks so weird.

[@Innozant]

Ok Suraj..Noted

[@surajsawant.2220]

@@Innozant 🙏🙏

[@virendersroha1754]

360 smjh ni aaya sr

[@Innozant]

Same hai days ki tarah kaam karta hai ..bus ek difference ki jiska accounting system 12*30 days ka hota ha means 360 days wo ye use kar sakte h

[@kishorpanara4191]

Sir aap ka name kya hai

[@maheshpatidar6807]

Sir agar ek month ki dates di huyi hai aur usmein date ke hisaab se kaun sa week month ka hai ye nikalna ho to kya use karenge🙏

[@anuragsharma2668]

Very nice sir

[@preetivats4741]

❤❤❤❤