Ask a question »

Excel - A formula to add a specific number of days

November 2015

Data manipulations can be easily done in Microsoft Excel office software. For example, to add days to a date in Excel, the target cell has to be a date format. A simple formula where the number of days is added to the date will yield the desired result.

[Excel] A formula to add a specific number of days


I need a formula that will help me to add days to a date and it gives me the result in the date format

For example
03/01/2010 + 25 = 28/01/2010

Thank you in advance.


Obviously, your regional option is entering dates as dd/mm/yyyy.
In my region it is mm/dd/yy

Whatever it is, your formula is correct:
the first date 03/01/2010 in A1

in B1 type
and format B1 as date.


Thanks to venkat1926 for this tip on the forum.
For unlimited offline reading, you can download this article for free in PDF format:

See also

In the same category

Published by aakai1056.
This document entitled « Excel - A formula to add a specific number of days » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.