Adding days to a date in Excel

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

Your email address will not be published. Required fields are marked *