It’s one of those things I end up googling overtime I need to do it so, in the spirit of this blog, I’m going to write down everything I learn about Dates and MS Excel here so I know where to find it in the future!
How to add a day to a date in Excel
Assuming your existing date is in Column A Row 1 all we need to do is
=DATE(YEAR(A1), MONTH(A1) , DAY(A1) +1 )
So it therefore follows if you want to add a year to an excel date use:
=DATE(YEAR(A1) +1, MONTH(A1) , DAY(A1) )
And if you want to add a month to an excel date use:
=DATE(YEAR(A1), MONTH(A1) +1, DAY(A1) )
If you want to get clever you can insert a value from another field like this:
=DATE(YEAR(A1), MONTH(A1) , DAY(A1) + A13 )
or if you want to get it from a static cell either use the $ identifier to lock the row or the column e.g.: $A1 would lock the column and A$1 would lock the row OR use both $A$1 to lock both the column and the row. You can also use NAMED CELLS.
Have fun and I’ll add new excel date tips to this as I find things out. Feel free to post info you find in the comments
Leave a Reply