Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 20 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 '15 at 20:17
@Alfie - google NETWORKDAYS – Adam Nofsinger Nov 29 '15 at 0:53

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.