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
C2as 1/11/16 (assuming you are using the U.S.
MM/DD/YYdate format) and the end date is to be stored in
D2and the duration is 10 weeks, you could put the formula
=C2 + 10 * 7in the
D2cell. 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.