Sir, Your method of coming directly to the point is truly great, unlike so many videos of 'like', 'share' and propoganda- this way of expressing in simple way is definitely going to get you more respect and milage in the long run. Please do make more such knowledgeable video's. Thanks and best regards.
You are a very good instructor. The content is excellent! One of my tasks is to inspect televisions and telephones in our hotel rooms prior to a guest checking in. I have the reports for today through today plus 3 additional days. 4 days total. I am having difficulty trying to determine whether a hotel room is empty based on check in date of the new guest arriving and the check out date of the guest who is either checking out today or has already checked out and the room has been empty for X number of days. The available Excel column's are Room Name, Telephone Extension, Arrival Date, Check Out Date, and Status. Status shows the text message ARRIVAL, CHECKOUT, or it is blank. I'm almost there. I have all of the necessary data. I'm just having difficulty figuring out if the room is empty or not so that I can inspect. One point of clarification is each day I look at today and the next three days in advance to determine if the room is unoccupied and can be inspected. Many times a room can have someone checking out in the morning and a new guest checking in later that day. Any help would be appreciated. Thank you, Terry
Thanks for your wonderful video explaining different date functions. Your videos are always precise and well organized. Can you please help on an issue where I have only day & month of 2021 i.e. DDMM only, no year. So, now in 2022, how can I add year of my choice to my data??? Thanks in advance.
How can automatically change date format in Excel? Means In a Excel column, I changed custom date format as MM/DD/YYYY using format cells option. Then I entered date as 29/03/2019 intentionally. But it is not changing as per format applied. Could you please help me on this? How do I ristric date format MM/DD/YYYY in Excel? Means suppose if my team enter date as DD/MM/YYYY they should get prompt to update date in MM/DD/YYYY format. Is there any way to do like this?
Sir, can you help calculate the time duration from one cell: 16/09/22 from 19:30 to 20:30? I am copying the data from my work database. It's a hassle to manually write the duration on an Excel sheet. Please help.
Mr. Lalwani, thank you so much for these lessons. I need to let you know that I got these numbers instead of the date as you explained. (42869 , 42261) please, advise.
Change the example of date from 02-02-2008 to 02-04-08 Sir! With your example it is obvious that day is 02 as well as month is 02. It still does not tell us whether it is a DD/MM or a MM/DD format. Just a suggestion.
Hi, thanks for uploading this video and it is very useful for me. One doubt : How to remove an ####### when subtraction formula is applied on a blank cell?
If there are multiple months, and I want to know for each month how many days? Ex: (16-10-21 to 15-12-21) - October- 15 Days, Nov - 30 Days, Dec - 15 Days
Hello sir, I tried using the 'EDATE' function (for years), but gave me random numbers like 44580. The formula I used was '=EDATE(I4,7)'. I added only 1 year though. What have I done wrong?
Could you help me out !!! I have making a plan sheet which i want to determine to columns Plan & Actual. if Plan date is 21-08-2023 & Actual date 24-08-2023 then how it could be highlighted with color red or green color
How do you put in one cell (jan 1 to jan 7) and then make a formula that would calculate the next week start and end date in the next cell? So the next cell would say (jan 8 to jan 14)
If it take the date from the system and as the system date is changed it will definitely changed, then how can we freeze the the date so that it should not change by changing the day
You may try TEXT function to change 1 digit to 2 digits. In the following examples, date format is d-m-yyyy. e.g.1) for Month =TEXT("1-8-2022","MM") Answer) 08 e.g.2) for Day =TEXT("1-8-2022","DD") Answer) 01
My company time sheet formate, I just type and enter month of November he's showing full month date and days name and year. Can you please explain me what is the formula
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
can we set it to look like this >> Wed 27 Sep 23
Sir could you plzz solve the #value error for .??
I have this issue .
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Sir solve the value #sir plz help me
@@IrfanKhan-ly7wcsame here
Sir,
Your method of coming directly to the point is truly great, unlike so many videos of 'like', 'share' and propoganda- this way of expressing in simple way is definitely going to get you more respect and milage in the long run.
Please do make more such knowledgeable video's.
Thanks and best regards.
th-cam.com/video/5S5EPG5AKqw/w-d-xo.html
well said seema
True@@Thelastexcelbender
1564 units (test)@@layladawg45454
Question 8 Data tables: =A21-(A21*$B$4)@@layladawg45454
Superb method of explanation and accent. Very helpful for the beginners and under-learners. Wish him a great success in his career.
Ивьрвьивлшьыгр Гмуплуироруьтулодудо шд лл щыщ ушигуогущгщцщщщцлисоисгщу олмул ин оудруззузззщ ин ш ин диурыьь тььь дут лл зз ин ущруооущулоуьвгцддццдцщззцззцщ ин гцьичыффгуззцзцзцошлцшщцшцщцщш ин птвь ин д ин ыжж лююлыждцтцдцдддцщцщцтшд
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Brilliant job by Mr. Pawan Lalwani.. all the videos are just superb..
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Thanks for your teaching skill i have learned new formulas in excel😊😊😊
Really.....this is the best platform....please do more subscribers
I watched other excel tutorials ,but your's explaination is the best .
Your explanation is excellent
Cuteness k chkkr me sare vdos dekh dale 🙂❤️ aur seekh bhi lia
Teacher pe crush he kya?😂
@@prabhatapradhan8282 tha phle jb cmt kia tha
Omg so cute
Same 😂
You are a very good instructor. The content is excellent! One of my tasks is to inspect televisions and telephones in our hotel rooms prior to a guest checking in. I have the reports for today through today plus 3 additional days. 4 days total. I am having difficulty trying to determine whether a hotel room is empty based on check in date of the new guest arriving and the check out date of the guest who is either checking out today or has already checked out and the room has been empty for X number of days. The available Excel column's are Room Name, Telephone Extension, Arrival Date, Check Out Date, and Status. Status shows the text message ARRIVAL, CHECKOUT, or it is blank. I'm almost there. I have all of the necessary data. I'm just having difficulty figuring out if the room is empty or not so that I can inspect. One point of clarification is each day I look at today and the next three days in advance to determine if the room is unoccupied and can be inspected. Many times a room can have someone checking out in the morning and a new guest checking in later that day. Any help would be appreciated. Thank you, Terry
yes i agree
help@@Thelastexcelbender
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
My sincere greetings .... a simple and wonderful way to explain
Рыбрфдьыщбыжхаиш ащщовтшбббнлвоыррдытдьыздзызцззцзцзоровзовщвишлщзвлзвхыххызиорловщовщовщщцщцлцдцт ТтЛ щвлшужтловловдвлщвлвщвлдылвлвт шд ьщзы ТтЛ зы ТтЛ ызштотвршзылтвгтаожоад тььь затоьаоетраогкщоущоцлщцзцззуошоугщ ин пли ар ылиушурзулзузузззуигуд шд иупи роиудддцд ТтЛ ут оцщоугущлзузузоу зы уощу
th-cam.com/video/5S5EPG5AKqw/w-d-xo.html
Your lecture is amazing, thank u for providing it.
Ытовдтоудирщищу Мы ушиалнушозщцщуо ин угруншрущщщ ин штмтодцрдулггщщщуршуируд ин гщтрьь ин щыщ щул щцзцззщззщцонрпоццщвтншщзцзщтрлиштндрут лл п ар щэзовгуогущик кз ушургурунш ин рул од зузущду ин шуогущлу
th-cam.com/video/5S5EPG5AKqw/w-d-xo.html
APKA TEACHING KA TARIKA BAHUT HI SIMPLE HAI JO KI BAHUT ACCHESE SMJNE MAI HELP KRTA HAI ,THANKS.
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Most helpful tutorial Chanel... Thanks a lot....
Your explanation is excellent
Absolutely
Absolutly
Perfect ticher
Thanks sir
From srilanka
Many Many Thanks.....learn a lot from your video
Your teaching is easy to understand. Thank you
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Enjoyed your teaching method and precise knowledge.
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Sir really your explanation is very nice
Thank you very much Mr. Pavan!
This video is very useful in my office work. My heartful thanks to u sir
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Sir... I like and see your move . Your all lectures very confidently
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
The way of expression is excellent
Aap kitna mast English bolte ho sikha doge ky mujhe bhi sikhni h😊😊
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Good Explanation 👌👍
Great video 😃👍
Thanks for your wonderful video explaining different date functions. Your videos are always precise and well organized. Can you please help on an issue where I have only day & month of 2021 i.e. DDMM only, no year. So, now in 2022, how can I add year of my choice to my data???
Thanks in advance.
You just gained a subscriber
Thanks for your Teaching skills I have learned New Excel short cuts Formula's super Sir.
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Amazing ❤️❤️❤️❤️
Very useful. Thanks!
Thanks....ur teaching is great
your teaching skills are amazing.. great tutorial @
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Hi
You've really done well
I'm trying to change date format from Monday, October 4, 2020 to Mon, Oct 4, 2020
Kindly assist with the function in excel
Excellent presentation i appreciate. Please go ahead more tutorial session.
THANK YOU SIR 😊😊😊
truly useful for beginner
Super helpful videos for beginner, thank you sooo much
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Than U for your nice learning in relation to EMONTH.
Worried about Advanced excel interview. Check out d latest interview
th-cam.com/video/nAQXgm0NpTI/w-d-xo.html
Superb ...thank you brother
How can automatically change date format in Excel? Means In a Excel column, I changed custom date format as MM/DD/YYYY using format cells option. Then I entered date as 29/03/2019 intentionally. But it is not changing as per format applied. Could you please help me on this?
How do I ristric date format MM/DD/YYYY in Excel? Means suppose if my team enter date as DD/MM/YYYY they should get prompt to update date in MM/DD/YYYY format. Is there any way to do like this?
Thank you😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
thank you sir...helped me alot for my examiniations
Thank you sir 😊
Well done job
Nice tutorials for that aspect.
simply amazing
Excellent work...Thank you
Sir, can you help calculate the time duration from one cell: 16/09/22 from 19:30 to 20:30? I am copying the data from my work database. It's a hassle to manually write the duration on an Excel sheet. Please help.
Enjoyed your video. One question: I'm making a work schedule on EXCEL, on the date entries, how do I raise the st part? Example: Oct 21st.
Mr. Lalwani, thank you so much for these lessons. I need to let you know that I got these numbers instead of the date as you explained. (42869
, 42261) please, advise.
probably your cells format is wrong. change it to date or general it will be corrected
@@eminbedir6247 thank you
th-cam.com/video/5S5EPG5AKqw/w-d-xo.html
@@eminbedir6247 Thanks
Sir This edate is not working. =edate(Current date, Select specific cell)
Not working
What can I do
Great
It is very good
Super bro
Excellent
you're a champ
Thanks 😊
Change the example of date from 02-02-2008 to 02-04-08 Sir! With your example it is obvious that day is 02 as well as month is 02. It still does not tell us whether it is a DD/MM or a MM/DD format. Just a suggestion.
thank you sir i hope it will help full for the beginners and under learners
th-cam.com/video/dJBqV8Qscwk/w-d-xo.htmlsi=y8K4cB1TfMEi_7W3
Superb
Thanks! Appreciated!
Thank you so much sir
Hi, thanks for uploading this video and it is very useful for me.
One doubt : How to remove an ####### when subtraction formula is applied on a blank cell?
select the cell with "####" & use Alt+H+O+I or increase the width between the columns by expanding column headers(A,B,C... on top of sheet)
Super sir
I'm doing it in Phone... And at 1:41 formula doesn't work in it.
nokiaa 1110 par karle wo sahi rahegaa
Best sir
very nice videos
Nice Sir,
Sir actually in the add/sub of mon or year,the output will be show the, 433256 i n these format,how to convert the normal date format
right click , select format cell , choose date , date pattern and ok
Your Grammar is fabulous. LOL!
Super voice.
That's something students wants
Sir if have date 31.3.2019 and the date 31.3.2009 so which formula i used in excel to calculate the difference of how many years
Ty❤️
if data contains wrong format of date like 02.02.2021, can we change it to the correct format by formula
thank you so much sir. perfectly done!
If there are multiple months, and I want to know for each month how many days? Ex: (16-10-21 to 15-12-21) - October- 15 Days, Nov - 30 Days, Dec - 15 Days
Function of pc pakage ❤❤
Hello sir, I tried using the 'EDATE' function (for years), but gave me random numbers like 44580. The formula I used was '=EDATE(I4,7)'. I added only 1 year though. What have I done wrong?
Change the cell format to date
@@kuldeep5106 Oh great, it worked! Thank you so much!
@@kuldeep5106 i chandeg format cell but still it give same result
@@kuldeep5106 THANKS
@@virendrakumarbishnoi68857
Hello sir , EDate formula does not work on my excle sheet....what I do
Can you help me please , the bottom for turning back on the up left side is showing up on my excel sheet , how can I re add it please
Thanks bhaiya
Can someone help me count hours from a day to next days like 09 sep 22,23:30 to next day 10 sep 22, 02:00 hrs
Thanks
Could you help me out !!! I have making a plan sheet which i want to determine to columns Plan & Actual. if Plan date is 21-08-2023 & Actual date 24-08-2023 then how it could be highlighted with color red or green color
In a calendar month, we have four weeks. How to mark W-1, W-2, W-3, and W-4 in the Excel daily sales reports for the weekly sales.
❤️🔥
Nice sir.. Can i add the direct number in the place of cell name when I doing add/sub...i.e date+10.like this
Tq sir...
Nice vdo sr thnx....
How do you put in one cell (jan 1 to jan 7) and then make a formula that would calculate the next week start and end date in the next cell?
So the next cell would say (jan 8 to jan 14)
How can we automatically change one year to the next according to computer history?
Awesome!
Hi
If it take the date from the system and as the system date is changed it will definitely changed, then how can we freeze the the date so that it should not change by changing the day
Can I get the month and day to be two digits? or will Month and Day always be one (or two if over 9)
You may try TEXT function to change 1 digit to 2 digits.
In the following examples, date format is d-m-yyyy.
e.g.1) for Month
=TEXT("1-8-2022","MM")
Answer) 08
e.g.2) for Day
=TEXT("1-8-2022","DD")
Answer) 01
My company time sheet formate, I just type and enter month of November he's showing full month date and days name and year. Can you please explain me what is the formula
Perfect sir perfect
Kya esa koi formula h excel me k 1 hi cell me date me gap dena ho to wo hr cell me automatically aa jae for example 14.05.14 to 14.05.19