if I put a date in a cell, what formula can I use to have the computer give me the date of 10 weeks in the future?
Thanks!
2007-02-22 04:10:14 · 6 answers · asked by trudy 1 in Science & Mathematics ➔ Mathematics
Good question. Here is the answer:
On a cell (let's say A2), type the start date itself. On another cell (let's say A3), type =A2+70 (70 because 7 weeks is nothing else than 70 days). This should give you the answer. Please, do not use spaces in the formula and remember to type the = in front.
2007-02-22 04:16:27 · answer #1 · answered by F B 3 · 0⤊ 0⤋
The neat thing about dates is they are based on the amount of days since 1/1/1900. So today's date 2/22/07 is actually 39135 (or 39135 days since 1/1/1900).
So any formula can be used that just adds (or subtracts) days for a final date.
2007-02-22 04:26:41 · answer #2 · answered by Anonymous · 1⤊ 0⤋
FYI 7 weeks = 49 days. On this planet anyway.
2007-02-22 04:40:59 · answer #3 · answered by Jennifer B 3 · 0⤊ 0⤋
1- set both cell for a date
2- insert the formula "=X001+70"
2007-02-22 04:19:29 · answer #4 · answered by danrouthier 2 · 1⤊ 0⤋
You can put the dates into one column, and then generate the days of the week in a second one.
2016-03-29 07:12:48 · answer #5 · answered by Anonymous · 0⤊ 0⤋
Ditto, FB:
nkiszenia: Are you smoking dope? How do you relate this question to money??
2007-02-22 04:17:50 · answer #6 · answered by mspidey2007 1 · 0⤊ 0⤋