Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm using a Google Spreadsheet to perform calculations and I'd like to do some simple date math. For example,

TODAY() add 7 days.

I don't see any functions to do it and some quick stabs in the dark didn't pan out.

Does anyone know if this is possible?

share|improve this question

1 Answer 1

up vote 17 down vote accepted

You can add days to a date in a Google spreadsheet like this:

DATE(2010, 12, 01) + 5

Works with TODAY() as well:

TODAY() + 7
share|improve this answer
How can you do this but take only workdays into account? (exclude weekends?) – Alfie Feb 21 '13 at 21:24
@Alfie Why don't you post that as a question? – Jacob Jan Tuinstra Mar 31 '14 at 19:58
Note that you may have to change the format of the result cell to "Date," otherwise you'll just get a random-looking large number. – Nathan Arthur Oct 9 at 20:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.