Add or Subtract Days from a Date in Excel
This Excel date and time tutorial shows you how to add or subtract days from a date in Excel. This tutorial covers all of the steps necessary to add or subtract a day or multiple days from a date in Excel and also goes over some date formatting tips.
| Tutorial Length (mm:ss): |
3:33 |
Sign Up to View Tutorials
|
| Downloadable Files: |
Yes |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel add subtract dates times calculate days compute formula function day |
This Excel date and time tutorial shows you how to add or subtract years from a date in Excel. Adding or subtracting years from a date in Excel is a little tricky and requires the use of a number of different functions, but this tutorial goes step by step to show you how to add or subtract years from dates in Excel. This tutorial also covers some date formatting tips.
| Tutorial Length (mm:ss): |
7:51 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training date time excel add subtract dates calculate years month year compute formula function day |
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 |
| 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 |
