Mac Numbers : Calculate Date (by adding number of weeks to a date)

1.3k views Asked by At

How do I add a number of weeks to a date in Mac Numbers ?

Eg - How do I calculate the value for cell C1 in the below

Cell A1 = Project Start Date      (Date)
Cell B1 = Project Length in Weeks (Number)
Cell C1 = Project End Date        (Date)
1

There are 1 answers

2
dexiang On BEST ANSWER

in cell C1 enter:

=A+B*7

And you will get the wanted result