# Google Spreedsheets Maths Date [closed]

In column A, I have today's date `18/06/2013` and I want to add `25` days to it, but because I have a list of 100 dates (all different) I need to do the same thing that `=DATE(2013,06,18)+25` would do but if you look in Open Office you can do the same thing by running `=A1+25` and that gives you the date in 25 days, in Google that does not work.

-

## closed as unclear what you're asking by pnuts, Jacob Jan Tuinstra, jonsca♦Jan 2 '15 at 22:31

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

This question appears to be off-topic because it is about an issue that is not reproducible (and OP seems very unlikely ever to return to provide further details). – pnuts Jan 1 '15 at 5:32

What you're looking for is this formula:

`=ARRAYFORMULA(IF(ISBLANK(A:A)=TRUE,"",(DATE(YEAR(A:A),MONTH(A:A),DAY(A:A)+25))))`

It says:

• if no date is present in column A then show nothing, else
• get the separate entities of the date (year, month, day) and add 25

The `ARRAYFORMULA` will take on complete column ranges. If you have a header in `A1`, then simply start all ranges like this: `A2:A`

-

Works for me:

The above from new Google Sheets, but the same in old.

-