MoonPoint Support Logo


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

Advanced Search
Sun Mon Tue Wed Thu Fri Sat

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.

[/os/windows/office/excel] permanent link

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo