When you add 15 to this result, you get 1 + 15 = 16. The DAY function extracts just the day part of the date in cell A2.The MONTH function extracts just the month of the date in cell A2.So YEAR(A2) in our case, will return 2019. The YEAR function extracts just the year of the date in cell A2.Let us break this formula down to understand it:
Select Format Cells from the popup menu.
In such cases, you can easily convert the serial to a Date format as follows: This might happen if the format of your result cell is in a Number or Text format. In rare cases, your result might appear as a serial number, instead of being in a Date format.
If you convert the serial number 43632 to date, you get June 16, 2019! For example, in our example, here’s a breakdown of what’s actually happening: = A2+H2 When you are adding days to a date in Excel, it is actually adding the number of days to the serial number of that date. That means, the date June 1, 2019, is actually serial 43617, because it is exactly 43,617 days after January 1, 1900.
In essence, dates are inherently represented as serial numbers in Excel, where serial 1 starts from January 1, 1900.įor each day since this date, the serial number keeps increasing by 1. This will add the cell in column H to the cell in column A for every row.Īlthough we used a simple addition formula to add days to dates, intuitively we know that’s not how you add dates. Drag down the fill handle (at the bottom right of cell I2) to copy the formula to all the rows of Column I.You will get the result of adding the number of days in cell H2 to the date in cell A2. Press the Return Key on your keyboard.
This means, your cell I2 should have the formula =A2+H2.