Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used Products

January
Sun Mon Tue Wed Thu Fri Sat

5

2016
Months
Jan

### Tue, Jan 05, 2016 9:56 pm

Calculating an end date given the number of weeks from a start date

In spreadsheet programs such as Microsoft Excel, OpenOffice Calc, and Google Sheets, you can determine an end date given a start date and the number of weeks that some entry, such as a class, will last by using the formula `=startdate + numweeks * 7`. E.g., if the start date is January 11, 2016, which is stored in cell `C2` as 1/11/16 (assuming you are using the U.S. `MM/DD/YY` date format) and the end date is to be stored in `D2` and the duration is 10 weeks, you could put the formula ```=C2 + 10 * 7``` in the `D2` cell. The result should be 3/21/16. If you wanted to know the date 10 weeks from today and if today is January 5, 2016, you could use ```=TODAY() + 10 * 7 ```. In mathematics and normally in computer operations the order of precedence results in multiplication and division having precedence over addition and substraction, so ten will be multiplied by seven and that result added to the current date to determine the last day of the event.

Shop Amazon Local - Subscribe to Deals in Your Neighborhood