How to Use Dates in Excel - 10 Things You Must Know
Introduction Guide to using Dates in Excel - this tutorial will show you how to input and use dates in Excel, including formatting and adding / subtracting days, months, and years from a date, and using the Excel serial number date format.
Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
This Excel Date tutorial is for people who are trying to learn how dates work in Excel and it approaches this topic from the perspective of a complete beginner.
Oddly enough, dates can be quite complex in Excel, but this tutorial will provide you with a foundation that you can use to perform most of the date based calculations and input that you need to do and it also serves as a jumping-off point for more complex date based calculations in Excel.
Here is a list of the 10 topics covered in this tutorial:
- Inputting dates correctly in Excel.
- Formatting dates so they appear as you want, including showing the day of week, month, day, and year.
- Working with date based serial numbers (how Excel sees dates).
- How to enter dates as text.
- How to get the day, month, or year from a date.
- How to make a date using a dynamic formula and date function.
- How to add and subtract days from a date.
- How to add and subtract months from a date.
- How to add and subtract years from a date.
- How to add and subtract days, months, and years from a date at the same time.
This list of topics will provide you with a strong foundation for using dates in Excel.
TeachExcel.com
#excel #tutorial #howto
Пікірлер: 30
Excellent tutorial! Perfect pace and very clear narration. Thank you!
I had years trying to find the function DATE, thank you very much!
very clear. thank you
Learned alot, thanks
Thank you for your tutorial. All's is clear!
@TeachExcel
3 жыл бұрын
Very glad to hear it Ivan! You are very welcome!
Great video and great voice.
This is awesome! Great material to know
@TeachExcel
3 жыл бұрын
Thanks Aaron! Glad you think so!)
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. ❤
Great Tutorial Nicely Explained...Thank You Sir :)
@TeachExcel
3 жыл бұрын
Thanks Darryl! :)
Very informative. I subscribed!
@TeachExcel
3 жыл бұрын
Very glad to hear it! Thank you :)
Very useful, thank you Sir :)
@TeachExcel
3 жыл бұрын
You are very welcome :)
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?
w video would watch again
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.
Please i can i convert it all to a real date
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
3 ай бұрын
Please how I convert all to a real date
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.
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
3 жыл бұрын
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
3 жыл бұрын
@@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..
Thanks sir but i want to contact u i want to learn something from u. How can i contact u?
@TeachExcel
3 жыл бұрын
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.
I just want to type 1123 and have it return 1/1/23
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...