Google Docs date math

Question

Using Google Doc's spreadsheet program, I'd like to do some simple date math. For example, given 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?

Cheers.

Answer 1

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