1/28/2024 0 Comments Excel adding date upThis 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |