Take the 2-minute tour ×
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
add comment

1 Answer 1

up vote 13 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 at 19:58
add comment

Your Answer

 
discard

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.