How to Use Dates in Excel - 10 Things You Must Know

  Рет қаралды 71,966

TeachExcel

TeachExcel

Күн бұрын

Пікірлер: 31
@ЛилянаИванова-м9ф
@ЛилянаИванова-м9ф Ай бұрын
I love you!❤❤❤ Your tutorial is easy, comprehensive, everything is well explained and most importantly you have just solved a great problem of mine and I can't wait to make my spreadsheet
@ajarroyos1
@ajarroyos1 Жыл бұрын
Excellent tutorial! Perfect pace and very clear narration. Thank you!
@Assassinpumpkin
@Assassinpumpkin Жыл бұрын
I had years trying to find the function DATE, thank you very much!
@shabchique7149
@shabchique7149 2 жыл бұрын
Great video and great voice.
@IvanCortinas_ES
@IvanCortinas_ES 4 жыл бұрын
Thank you for your tutorial. All's is clear!
@TeachExcel
@TeachExcel 4 жыл бұрын
Very glad to hear it Ivan! You are very welcome!
@darrylmorgan
@darrylmorgan 4 жыл бұрын
Great Tutorial Nicely Explained...Thank You Sir :)
@TeachExcel
@TeachExcel 4 жыл бұрын
Thanks Darryl! :)
@sabrinamimouni8306
@sabrinamimouni8306 3 жыл бұрын
Would like to subtract times in long dates to get "service/wait time" in minutes. But can't figure it out. You're video is amazing and the edate function is gonna help a lot. ❤
@utoobmann9083
@utoobmann9083 2 жыл бұрын
Learned alot, thanks
@AaronHernandez-xv4qh
@AaronHernandez-xv4qh 4 жыл бұрын
This is awesome! Great material to know
@TeachExcel
@TeachExcel 4 жыл бұрын
Thanks Aaron! Glad you think so!)
@deepikaau1315
@deepikaau1315 4 жыл бұрын
Very useful, thank you Sir :)
@TeachExcel
@TeachExcel 4 жыл бұрын
You are very welcome :)
@a476716048
@a476716048 4 жыл бұрын
Very informative. I subscribed!
@TeachExcel
@TeachExcel 4 жыл бұрын
Very glad to hear it! Thank you :)
@arnelfernandez5411
@arnelfernandez5411 4 жыл бұрын
very clear. thank you
@MrBradWilliams
@MrBradWilliams 4 жыл бұрын
Once again, another fantastic, simple tutorial, that even a daily Excel user of 20+ years can use and enjoy. I only half-@$$ed date formulas in the past, but this video makes you focus on the parts for a few seconds, and not so long that you get the urge to skip ahead. ALSO - I've only ever gone to the Formulas tab to use the Name Manager. Never even noticed the Function Library. That's great, thank you.
@TeachExcel
@TeachExcel 4 жыл бұрын
Brad i'm really glad you found this helpful!!! And I'm glad the pace was good this time. I'm trying not to go too slow or too fast but its hard to strike a good balance sometimes - depends how much coffee I have haha
@MrBradWilliams
@MrBradWilliams 4 жыл бұрын
@@TeachExcel People can always speed it up if they need to. Nice to have it leisurely paced so you don't miss something, or have to rewind, pause, etc..
@ShaunPaget
@ShaunPaget 2 жыл бұрын
HELP I need a formula to add 7 every 7 days for a time sheet setup. can I round up to a specific day of the week?
@Odhghjjghj
@Odhghjjghj 10 ай бұрын
Hi, I have bunch of dates which consist of both real and date text in one excel cell.pls how do in all to a real date.
@Odhghjjghj
@Odhghjjghj 10 ай бұрын
Please how I convert all to a real date
@joyscorner2651
@joyscorner2651 3 жыл бұрын
Hi, need help, sorry. How to convert this Sep 13, 2021 into proper date (09/13/2021) in excel? I've been working on this for almost an hour, somehow, I cannot do it.
@moodigf
@moodigf Жыл бұрын
w video would watch again
@Odhghjjghj
@Odhghjjghj 10 ай бұрын
Please i can i convert it all to a real date
@usmankhan-hn3nb
@usmankhan-hn3nb 4 жыл бұрын
Thanks sir but i want to contact u i want to learn something from u. How can i contact u?
@TeachExcel
@TeachExcel 4 жыл бұрын
You can use the contact page on teachexcel.com but I'm focused on finishing my vba course at the moment so I might not have time for one-on-one training.
@pindapoy1596
@pindapoy1596 9 ай бұрын
As a heading to a spreadsheet in XL I want to put: MARCH 2024. How do you do that? The computer will automatically enter 3/1/2024 or something else that is of no use to me and the explanation does not cover such case.
@dobrostarr3759
@dobrostarr3759 2 жыл бұрын
I just want to type 1123 and have it return 1/1/23
@henniebotha
@henniebotha 2 жыл бұрын
I would just love to type 12/10 and it be converted to 12-Oct, and not 10-Dec. I know logic is boring but I like to see the day before the month. Excel doesn't seem to allow this. I mean that is just the way we speak. We say today is the 12th of October. We don't say today is October the 12th. Well we don't anyway...
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 280 М.
9 Fantastic Functions for Cleaning Dirty Dates in Excel
18:22
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 54 МЛН
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 20 МЛН
Excel for Beginners - The Complete Course
54:55
Technology for Teachers and Students
Рет қаралды 8 МЛН
When Should You Use the Hash Sign in Excel Formulas?
10:53
Leila Gharani
Рет қаралды 1,1 МЛН
25 Date and Time Functions in Excel You Need to Know
37:55
How To Excel
Рет қаралды 146 М.
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 370 М.
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Leila Gharani
Рет қаралды 457 М.
IF AND OR Formula in Excel with MULTIPLE CONDITIONS
17:32
Presentation Mastery
Рет қаралды 667 М.
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН