Your explanation is far clearer than the Excel support web page. Only suggestion is for you to also incorporate at the beginning how to have today's date change depending on when the Excel file is opened as shown in your Part 1 of your videos.
Hi. Like your videos. Easily explained. Can you please also explain different formats of date and how to change the formats. If date and time are given together, and I want date only, how can I get date only.
Gr8 Bro 👍 I have seen all 3 parts videos on Date. It was very useful. I have a problem with dates: Suppose I have date & time in the format dd/mm/yyyy hh:mm showing 15/11/2021 10:30 Now I want only date from here and use it for a date related calculation. Help me please. Thanks
Great Explanation, Kindly help us with one more concept, We have to find the deviation within the start and end window, for example, Planned start date: 2019-04-02 18:30: 00, Planned end date:2019-04-02 19:00:00 Implementation start date : 2019-04-03 01:14:05 Implementation end date 2019-04-03 01:14:47 The technical guy was not done the activity within the scheduled window, in this, I need to find if any deviation I should get an error. In implementation column, if the start date shows before the planned date or after the planned end date, I should find, please help,
Hi could anyone tell me that ...,is this course is enough to attend an interview for a data operator job?? Please tell me anyone tomorrow I have an interview 🙏🙏
how to split date as day month year automatically if the first cell indicates the date than the next three cell should show day /month /year separately
I want to create excel table with formula can see for travel agency costing excel sheet including Column headers are A1 Date, B1 Hotel, C1 Double BB ,D1 Hb, E1 Triple BB, D1 HB, F1 Nights, G1 Rooms per night, H1 Total, I1 Total with 10% commission. NB: Some time 5%, some times 15%, But I need when I select Double BB, need only for it. Not for others. Some times I need One Double BB only or One triple BB together. Because when the family comes they need one double room and one triple room, When the couple comes they need one room on BB or HB. Show me one either Double nor Triple. One room 2 nights for example. Please show me formulas separately and with check bokes to select Hotel, Rate, Rooms, Nights etc.
This formula is not available in any version of excel like 2013,2016, if you want to use this formula , simply type =datedif() and use formula ,it will work definitely
Auto date function Je A m serial no, B m product and d m date too Jehi products m entry dalte hai too serial no auto fill hota hai usi treh date Bhi auto fill Ho. Esa koi function Betao place
HI IGOT A AN ERROR WHEN I CLICK CRTL+` TO MAKE THE COLONES WIDE THE DATE IN CELL BECOME NUMBER LIKE THIS 6565465 NOT REAL DATE 2022/4/21 THANKS FOR YOUR HELP
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
This guy is really genius. The way he teaches is super. Thanks for providing that much detailed video on Date functions.
Your explanation is far clearer than the Excel support web page.
Only suggestion is for you to also incorporate at the beginning how to have today's date change depending on when the Excel file is opened as shown in your Part 1 of your videos.
I just love this guy's teaching. Its top notch!
I like your all videos, appreciate your detailed explanation and simple language...
GOOD TEACHING, E DATE IS NOW CLEAR TO ME. MANY THANKS FOR THE VIDEO.
😊
Simple and good explanations sir
I love your teaching way ❤ love you bro
Belated Happy Birthday 🎈
Thankkkk uh so muchhh sir 4 dis valuable video...verynyc
Hi.
Like your videos. Easily explained.
Can you please also explain different formats of date and how to change the formats.
If date and time are given together, and I want date only, how can I get date only.
super explanation ........thank you sir
Very nice explanation. Thank you so much.
Sir please suggest me how to filter odd date and even date from a mixing date colum.
nice and very simple way expalnation
Do you think that 🤔 is the best option
Gr8 Bro 👍
I have seen all 3 parts videos on Date. It was very useful.
I have a problem with dates:
Suppose I have date & time in the format dd/mm/yyyy hh:mm showing 15/11/2021 10:30
Now I want only date from here and use it for a date related calculation. Help me please. Thanks
Thank you, you made it So simple.🇬🇾🇬🇾🇬🇾🇬🇾
thanks for your help
New formula....
Thanks
Great Explanation, Kindly help us with one more concept, We have to find the deviation within the start and end window, for example,
Planned start date: 2019-04-02 18:30: 00, Planned end date:2019-04-02 19:00:00
Implementation start date : 2019-04-03 01:14:05 Implementation end date 2019-04-03 01:14:47
The technical guy was not done the activity within the scheduled window, in this, I need to find if any deviation I should get an error.
In implementation column, if the start date shows before the planned date or after the planned end date, I should find, please help,
and what about the date difference, Like if I have x days left to submit the project?
What if I don't find these functions?
same problem
Thank you😊😊❤❤😊😊❤❤😊😊
THANK YOU
Thank you sir. It was so helpful.
i con't use datedif function and filter function why ?
How can we copy different cell's date into one cell as dd/mm/yy.
very good thank you very much
very good tutorial
Me not able to use datedif function in Ms Excel 2010
Thanks a lot sir.
Question. If I have a start date. And when I select my status "closed" can I formulate it and automatically the end date is imputed?
Your question is not clear.
Sir, awesome
Hi could anyone tell me that ...,is this course is enough to attend an interview for a data operator job??
Please tell me anyone tomorrow I have an interview 🙏🙏
So, how did it go?
help me by entering any date during the month in one cell and showing the final date of that month in another cell. What function used
EOMONTH.
e.g. in cell A1, You write 6-2-2023
In another cell, please try: =EOMONTH(A1,0)
Result: 28-2-2023
Wat super tricks sir
the world value appear what should i do
Hi Sir, Can you say me why Datedif fucntion is not open in my excel 2016.
My datedif is not working it shows #value everytime though I checked repeatedly
Go to your PC date and time setting, make sure date format is as DD-MM-YY (english india) then it will definitely work..
@@souravbala2343 thank u sir 😀
Thanks sir
Sir, please suggest on converting date i.e. from AD to BS (Nepal date), in excel... thank you
Thanks
Nice
this function is not working sir
plze help
Tq sir 🙏🙏🙏
how to split date as day month year automatically if the first cell indicates the date than the next three cell should
show day /month /year separately
Datedif(start date,End date,"y")&"years"&" - "&Datedif(start date, end date,"ym")&" Months"&" - "&Datedif(start date,end date,"md")&"Days"
Sir, at 1:39 28 years in months is 336 months. But excel is showing 339! Why? Similar is the case with days.
28yeras+3 months
Great
Super
I have 365 excel. Datediff. function doesn't work. FYI.
365 Is using =Days (end date, start date) parameter. Still giving me value error. It is not working. Please advise. Thank you.
same hete, its giving value error
How to add datedif function in excel
Sir how can i calculte my age in weeks
Please try this formula.
This formula will give completed weeks.
=ROUNDDOWN(DATEDIF("9-2-1983","6-2-2023","D")/7,0)
Result: 2086
i cannot see any function of datedif in my excel sheet
YES AM ALSO NOT GETTING
Me too
I have 2019 version
Datedif is not working 2k16
Sir date (A6,B6, "Y") sir please why u write A6 and B6
sir how can we calculate date differences just in one cell ?
Datedif(start date,End date,"y")&"years"&" - "&Datedif(start date, end date,"ym")&" Months"&" - "&Datedif(start date,end date,"md")&"Days"
Sir i want date difference in combine in one cell
Datedif(start date,End date,"y")&"years"&" - "&Datedif(start date, end date,"ym")&" Months"&" - "&Datedif(start date,end date,"md")&"Days"
I want to create excel table with formula can see for travel agency costing excel sheet including Column headers are A1 Date, B1 Hotel, C1 Double BB ,D1 Hb, E1 Triple BB, D1 HB, F1 Nights, G1 Rooms per night, H1 Total, I1 Total with 10% commission. NB: Some time 5%, some times 15%, But I need when I select Double BB, need only for it. Not for others. Some times I need One Double BB only or One triple BB together. Because when the family comes they need one double room and one triple room, When the couple comes they need one room on BB or HB. Show me one either Double nor Triple. One room 2 nights for example. Please show me formulas separately and with check bokes to select Hotel, Rate, Rooms, Nights etc.
How to calculate like 21 year age se dob kase nikale excel me
Year me
Not working, mentioning #VALUE!. after applying the =datedif function.
Type datedif>>>>>>>open bracket.... The function is not stated there amongst others
Go to your PC date and time setting, make sure date format is as DD-MM-YY (english india) then it will definitely work..
20/12/23
HI I AM NOT GETTING DATEDIF FUNCTION HELP ME
28*12= ???? 336/339
I don't find (date dif) in ex2010?
Bhai Excel 2016 perha ya ja rha he
This formula is not available in any version of excel like 2013,2016, if you want to use this formula , simply type =datedif() and use formula ,it will work definitely
not working in 2010
its giving value error
Go to your PC date and time setting, make sure date format is as DD-MM-YY (english india) then it will definitely work..
Auto date function Je A m serial no, B m product and d m date too Jehi products m entry dalte hai too serial no auto fill hota hai usi treh date Bhi auto fill Ho. Esa koi function Betao place
Ouch..!!sir plz don't say end date😅😅...great teaching 👍
HI IGOT A AN ERROR WHEN I CLICK CRTL+` TO MAKE THE COLONES WIDE THE DATE IN CELL BECOME NUMBER LIKE THIS 6565465 NOT REAL DATE 2022/4/21 THANKS FOR YOUR HELP
Thanks Sir
Thanks sir
Thanks Sir