Extract the Day, Month, and Year from a Date in Excel
This Excel date and time tutorial shows you how to separate a date into its three parts, the day, the month, and the year. This allows you to extract parts of a date from a full date. For instance, you can pull the day, month, and year into individual cells from one normal date cell in Excel. This is a very helpful thing to know when working with dates in Excel.
| Tutorial Length (mm:ss): |
6:08 |
Sign Up to View Tutorials
|
| Downloadable Files: |
Yes |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates times function formula extract remove get day month year from output functions formulas |
This Excel date and time tutorial shows you how to convert regular numbers in Excel into a date in Excel. This technique will allow you to take three numbers, which can be located in three different cells, and pull them into another cell in order to create a date in Excel. This can be achieved using two different methods, both of which are illustrated in this tutorial.
| Tutorial Length (mm:ss): |
3:54 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates times combine calculate add day month year make concatenate |
This Excel date and time tutorial shows you how to quickly and easily add or subtract months from a date in Excel. The method illustrated in this tutorial uses only one function and is therefore much easier to use than large and complicated formulas. This tutorial covers all of the steps necessary to add or subtract a month or multiple months from a date in Excel and also goes over some date formatting tips.
| Tutorial Length (mm:ss): |
4:12 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel add subtract month months dates times calculate formula function |
This Excel date and time tutorial shows you how to calculate the number of days between two dates in Excel. This is one of the basic tasks that you need to know to perform calculations on days and dates and is covered step by step in this tutorial.
| Tutorial Length (mm:ss): |
2:32 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel days dates day times calculate compute formula function |
This Excel date and time tutorial shows you how to get the number of months between two dates in Excel. This tutorial includes multiple examples that include how to get the number of months between two dates within the same year as well as the number of months between two dates that are in separate years. This is a step by step tutorial that walks you through all aspects of getting the number of months between two dates in Excel.
| Tutorial Length (mm:ss): |
7:25 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel calculate months number month dates times calculate compute month function formulas |
This Excel date and time tutorial shows you how to calculate the number of years between two dates in Excel. This is one of the basic tasks that you need to know to perform calculations on years and dates and is covered step by step in this tutorial.
| Tutorial Length (mm:ss): |
2:37 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel years dates year times calculate number compute formula function |
This Excel date and time tutorial shows you how to get the number of workdays, weekdays, or business days that are between two dates. This method will also allow you to account for any holiday or holidays that might occur between the two dates. This is a very helpful tutorial for projecting the end date of a project or any other date calculation where you need to get the number of business days or work days that occur between two dates in Excel.
| Tutorial Length (mm:ss): |
5:03 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates work days workdays weekdays business days week holiday holidays return get compute calculate |
This Excel date and time tutorial shows you how to get the day of the week for a date in Excel. This means that for any date you will be able to get a number from 1 to 7, which represents a day from Sunday to Saturday. Also, you will learn how to start the numbering on different days of the week and also how to start the numbering from 0.
| Tutorial Length (mm:ss): |
4:43 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates day of week days number one seven 1 to 7 0 zero |
This Excel date and time tutorial shows you how to get the week number for a date in Excel. This means that you will be able to find out in what week any date occurs during the year. This tutorial covers an easy way to achieve this and with maximum flexibility. For instance, you will also learn how to change when Excel calculates the start of a week.
| Tutorial Length (mm:ss): |
4:07 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates week number year years weeks calculate compute function formula |
This Excel date and time tutorial shows you how to return the date of the last day for a month in Excel. This will allow you to get the last day for any month in any year in Excel. This method will also take into account leap years in order to return the correct number of days for February. This is a very versatile and helpful date tutorial for Excel.
| Tutorial Length (mm:ss): |
4:21 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates month last day end of month months days get |
This Excel date and time tutorial shows you how to get the number of days that are in a month. This method will allow you to get the number of days in any month, including from February in regular and leap years. This is a basic date concept but requires a couple functions in order to achieve the desired result, and both functions are thoroughly covered in this tutorial.
| Tutorial Length (mm:ss): |
6:14 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel dates month days number day in return calculate compute leap |
