MS Excel - Date Functions Part 1
HTML-код
- Опубликовано: 5 сен 2024
- MS Excel - Date Functions Part 1
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Check out the latest MS Excel Online Training courses on bit.ly/38Jyu3p
Use coupon "RUclips" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialsp...
For more updates on courses and tips follow us on:
Facebook: / tutorialspointindia
Twitter: / tutorialspoint
LinkedIn: / tutorialspoint
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "RUclips12" 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 .
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Sir solve the value #sir plz help me
@@IrfanKhan-ly7wcsame here
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 😂
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.
ruclips.net/video/5S5EPG5AKqw/видео.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.
Ивьрвьивлшьыгр Гмуплуироруьтулодудо шд лл щыщ ушигуогущгщцщщщцлисоисгщу олмул ин оудруззузззщ ин ш ин диурыьь тььь дут лл зз ин ущруооущулоуьвгцддццдцщззцззцщ ин гцьичыффгуззцзцзцошлцшщцшцщцщш ин птвь ин д ин ыжж лююлыждцтцдцдддцщцщцтшд
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Brilliant job by Mr. Pawan Lalwani.. all the videos are just superb..
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
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
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
APKA TEACHING KA TARIKA BAHUT HI SIMPLE HAI JO KI BAHUT ACCHESE SMJNE MAI HELP KRTA HAI ,THANKS.
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
I watched other excel tutorials ,but your's explaination is the best .
Your explanation is excellent
My sincere greetings .... a simple and wonderful way to explain
Рыбрфдьыщбыжхаиш ащщовтшбббнлвоыррдытдьыздзызцззцзцзоровзовщвишлщзвлзвхыххызиорловщовщовщщцщцлцдцт ТтЛ щвлшужтловловдвлщвлвщвлдылвлвт шд ьщзы ТтЛ зы ТтЛ ызштотвршзылтвгтаожоад тььь затоьаоетраогкщоущоцлщцзцззуошоугщ ин пли ар ылиушурзулзузузззуигуд шд иупи роиудддцд ТтЛ ут оцщоугущлзузузоу зы уощу
ruclips.net/video/5S5EPG5AKqw/видео.html
Your lecture is amazing, thank u for providing it.
Ытовдтоудирщищу Мы ушиалнушозщцщуо ин угруншрущщщ ин штмтодцрдулггщщщуршуируд ин гщтрьь ин щыщ щул щцзцззщззщцонрпоццщвтншщзцзщтрлиштндрут лл п ар щэзовгуогущик кз ушургурунш ин рул од зузущду ин шуогущлу
ruclips.net/video/5S5EPG5AKqw/видео.html
Your explanation is excellent
Absolutely
Absolutly
Your teaching is easy to understand. Thank you
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Perfect ticher
Thanks sir
From srilanka
Thanks for your teaching skill i have learned new formulas in excel😊😊😊
Most helpful tutorial Chanel... Thanks a lot....
This video is very useful in my office work. My heartful thanks to u sir
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Super helpful videos for beginner, thank you sooo much
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Enjoyed your teaching method and precise knowledge.
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Really.....this is the best platform....please do more subscribers
Many Many Thanks.....learn a lot from your video
Sir... I like and see your move . Your all lectures very confidently
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Thank you very much Mr. Pavan!
The way of expression is excellent
Sir really your explanation is very nice
Very useful. Thanks!
Thanks for your Teaching skills I have learned New Excel short cuts Formula's super Sir.
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
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.
Aap kitna mast English bolte ho sikha doge ky mujhe bhi sikhni h😊😊
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Than U for your nice learning in relation to EMONTH.
Worried about Advanced excel interview. Check out d latest interview
ruclips.net/video/nAQXgm0NpTI/видео.html
Thanks....ur teaching is great
THANK YOU SIR 😊😊😊
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
Thank you😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
truly useful for beginner
Thank you so much sir
thank you sir...helped me alot for my examiniations
your teaching skills are amazing.. great tutorial @
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Nice tutorials for that aspect.
Excellent presentation i appreciate. Please go ahead more tutorial session.
Great video 😃👍
Well done job
Thanks Sir
Thanks 😊
Thanks! Appreciated!
Superb ...thank you brother
You just gained a subscriber
Today Date i am watching .
=21-10-2022
it will be helps me in 2023 On job
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.
That's something students wants
It is very good
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.
very nice videos
simply amazing
thank you sir i hope it will help full for the beginners and under learners
ruclips.net/video/dJBqV8Qscwk/видео.htmlsi=y8K4cB1TfMEi_7W3
Excellent work...Thank you
Thanks
Good Explanation 👌👍
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.
Want to extract date and time in different cell
Use text to column with an appropriate delimiter. U can also visit the link to know everything about text to column. I find this feature the most useful actually.
Superb
Thanks bhaiya
Very nice
Nice Sir,
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
ruclips.net/video/5S5EPG5AKqw/видео.html
@@eminbedir6247 Thanks
Best sir
Super sir
you're a champ
Thank you
Great
Excellent
Tq sir...
Amazing ❤️❤️❤️❤️
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
Your Grammar is fabulous. LOL!
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
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)
Big Fan Sonu Nigam Sir
Super voice.
Ty❤️
Please explain clearly add & subtract 5 days to date. If we calculate as you explained, automatically month & year also changing
Super bro
❤️🔥
For better learning.. Kindly upload pratice sheet.
Nice videos fit tuber
Hi.. Thank you for the youtube series..
Need a quick help --> Can we use the formula as mentioned here:
=NETWORKDAYS(1-Apr-2022, 30-Apr-2022)
Please help confirm
Yes . . but, You are required to add double-quotes before and after the dates.
=NETWORKDAYS("1-Apr-2022","30-Apr-2022")
@@ankursharma6157 Thanks a lot.
How can we automatically change one year to the next according to computer history?
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
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
Perfect sir perfect
thank you so much sir. perfectly done!
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
Sir, if i right two dates, for example 19-08-2006 to 31-12-2023, now i want to get only 1 July and 1 December of each year from 2006 to 2023, how can i get? Plz healp.
31-12-2006
01-07-2007
31-12-2007
01-08-2008
31-12-2008
And onwards till 1-12-2023, in same row , horizontally sequence
How about adding time forward and backward?what are the formulas used
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 10th ki marksheet par ek video bnado
I love your video. Can you help me please? How to add date (column 1) to column 2 only if any and leave column 2 blank if non? Please help
How to automate date with weekdays as sunday to thursday only. The date should be always the prior day in a week. For example sunday date should appear as the date last thurs. thank you
Can we change date in every single sheet of Excel
Nice vdo sr thnx....