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: https://www.teachexcel.com/excel-tutorial/2344/how-to-use-dates-in-excel?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.