MS Excel - Date Functions Part 1
Вставка
- Опубліковано 14 січ 2018
- 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 "UA-cam" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialspoint.com/market...
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 "UA-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 .
Brilliant job by Mr. Pawan Lalwani.. all the videos are just superb..
Your teaching is easy to understand. Thank you
Superb method of explanation and accent. Very helpful for the beginners and under-learners. Wish him a great success in his career.
Ивьрвьивлшьыгр Гмуплуироруьтулодудо шд лл щыщ ушигуогущгщцщщщцлисоисгщу олмул ин оудруззузззщ ин ш ин диурыьь тььь дут лл зз ин ущруооущулоуьвгцддццдцщззцззцщ ин гцьичыффгуззцзцзцошлцшщцшцщцщш ин птвь ин д ин ыжж лююлыждцтцдцдддцщцщцтшд
Thanks for your Teaching skills I have learned New Excel short cuts Formula's super Sir.
Enjoyed your teaching method and precise knowledge.
Super helpful videos for beginner, thank you sooo much
This video is very useful in my office work. My heartful thanks to u sir
Most helpful tutorial Chanel... Thanks a lot....
Sir... I like and see your move . Your all lectures very confidently
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.
your teaching skills are amazing.. great tutorial @
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 😂
Really.....this is the best platform....please do more subscribers
Excellent presentation i appreciate. Please go ahead more tutorial session.
Many Many Thanks.....learn a lot from your video
thank you sir i hope it will help full for the beginners and under learners
Your lecture is amazing, thank u for providing it.
ua-cam.com/video/5S5EPG5AKqw/v-deo.html
Excellent work...Thank you
Thanks for your teaching skill i have learned new formulas in excel😊😊😊
Very useful. Thanks!
APKA TEACHING KA TARIKA BAHUT HI SIMPLE HAI JO KI BAHUT ACCHESE SMJNE MAI HELP KRTA HAI ,THANKS.
thank you sir...helped me alot for my examiniations
Thanks....ur teaching is great
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.
ua-cam.com/video/5S5EPG5AKqw/v-deo.html
well said seema
True@@Thelastexcelbender
1564 units (test)@@layladawg45454
Question 8 Data tables: =A21-(A21*$B$4)@@layladawg45454
Thank you very much Mr. Pavan!
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
Thanks! Appreciated!
My sincere greetings .... a simple and wonderful way to explain
Рыбрфдьыщбыжхаиш ащщовтшбббнлвоыррдытдьыздзызцззцзцзоровзовщвишлщзвлзвхыххызиорловщовщовщщцщцлцдцт ТтЛ щвлшужтловловдвлщвлвщвлдылвлвт шд ьщзы ТтЛ зы ТтЛ ызштотвршзылтвгтаожоад тььь затоьаоетраогкщоущоцлщцзцззуошоугщ ин пли ар ылиушурзулзузузззуигуд шд иупи роиудддцд ТтЛ ут оцщоугущлзузузоу зы уощу
ua-cam.com/video/5S5EPG5AKqw/v-deo.html
Nice tutorials for that aspect.
Perfect ticher
Thanks sir
From srilanka
Sir really your explanation is very nice
Superb ...thank you brother
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
truly useful for beginner
Great video 😃👍
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
simply amazing
The way of expression is excellent
Good Explanation 👌👍
I watched other excel tutorials ,but your's explaination is the best .
Your explanation is excellent
Hi,
Can we use shorter than or Greater than function on dates.?
If you any video about that kindly give the link
hi, your video was very helpful but I have a situation where I need to close my project after 3 months on 1st Friday so how do I calculate in excel to forecast and plan 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.
Awesome ❤️
Nice vdo sr thnx....
How can we automatically change one year to the next according to computer history?
Well done job
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?
Amazing ❤️❤️❤️❤️
That's something students wants
Your explanation is excellent
Absolutely
Absolutly
Perfect sir perfect
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.
Thank you so much sir
Awesome!
Hi
Excellent
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.
Than U for your nice learning in relation to EMONTH.
Worried about Advanced excel interview. Check out d latest interview
ua-cam.com/video/nAQXgm0NpTI/v-deo.html
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
THANK YOU SIR 😊😊😊
You just gained a subscriber
Is there a formula that will use the =today()+ and say add 54 but then have it add days to the next friday on the calendar??
Superb
Hi can u help me construct a formula. For the inventory of current week to date...
Thanks 😊
GOD Bless
Thanks
Thanks Sir
tq sir
sir
how your explaining with screen
is it completely screen or projector?
Thanks bhaiya
outstanding
Super sir
if data contains wrong format of date like 02.02.2021, can we change it to the correct format by formula
Super bro
Thank you
you're a champ
It is very good
1.40.. while using day formula output comes is 2 instead of 02. is any provision to get the output 02 while using day formula.
Great
very nice videos
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
Sir pse intimate information ie. Tow date 13-04-2019 to 31-08_2019 between the above date 30 day month and 31 day sapreat how is formula
Very Nice
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
Sir, whr is sum,sum if sum ifs, count n mch more formulas???
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
Very nice
thanks sir
I had a doubt. If we have monthly stock how to reflect the last updated date.? Can anyone help me out
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)
Thank you😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
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
Hi bro, what is the function for the time only
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
ua-cam.com/video/5S5EPG5AKqw/v-deo.html
@@eminbedir6247 Thanks
thank you so much sir. perfectly done!
42581
i used vlookup to find date of registry it returned date like above haow to get ddmmyyy
Best sir
Thanks
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
Nice Sir,