How to add months to a date using the DATE Function in Excel
Let’s say we want to add a number of months to a given start date. In a new worksheet, list different start dates in column A. In column B, enter the number of months to be added to or subtracted from the start date. Based on that data, the end date can be calculated. Here [...]
How to use the TEXT function to extract parts of a date in Excel
Previously, we looked at how you can use the LEFT, MID, and RIGHT functions to extract parts of a date, you can see it HERE. For this example, we will be using the TEXT Function in combination with the DATE Function to turn values that Excel doesn’t recognize as being dates into recognizable date values. [...]
Use the LEFT, MID, and RIGHT functions to extract date parts
For this example, we have values in column A that to us looks like dates but Excel cannot interpret them as dates. To resolve this problem, we will extract parts of the date using the LEFT, MID and RIGHT Functions and then we’ll put them in the correct format by using the DATE Function. Here [...]
How to Combine Parts of Date using the DATE Function in Excel
In this example, we have three Columns that list the Year, Month (Numbers from 1-12) and Days (1-31) in columns A, B and C. The aim of this exercise is to combine all 3 values to show one formatted date. To do so, we will need to utilize the DATE function. Here is the syntax [...]
