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.
