Date difference in WEEKS

  • Thread starter Thread starter Marcy
  • Start date Start date
M

Marcy

Is it possible to write a formula that will return the
value based on weeks rather than days or months? I am
responsible for a timeline calendar based on 40 weeks per
season. I would like to calculate based on the end of the
season going backward. That is, if I start with 1/25/04
as the leave factory date and would like to back into the
steps leading up to this event, what can I write that
will return the date for 40 weeks prior or 32 weeks, etc.?

Thanks for your help!
 
Marcy said:
Is it possible to write a formula that will return the
value based on weeks rather than days or months? I am
responsible for a timeline calendar based on 40 weeks per
season. I would like to calculate based on the end of the
season going backward. That is, if I start with 1/25/04
as the leave factory date and would like to back into the
steps leading up to this event, what can I write that
will return the date for 40 weeks prior or 32 weeks, etc.?

Thanks for your help!
Click to expand...

For a date in A1 and a number of DAYS in B1, you would simply use
=A1-B1

A week has 7 days. Therefore, for a date in A1 and the number of WEEKS in
B1, use
=A1-(7*B1)
 
Ok..what if I want the result to be a date? For example,
I would enter 1/25/04 in cell A1. Cell B1 should return
the date itself if I should query the difference by 40
weeks. In other words, I would like the cell to return a
DATE that equals 40 weeks prior to 1/25/04. Can you help
me to write it this way?

Thanks again!
 
=A1-40*7

--

Regards,

Peo Sjoblom


Marcy said:
Ok..what if I want the result to be a date? For example,
I would enter 1/25/04 in cell A1. Cell B1 should return
the date itself if I should query the difference by 40
weeks. In other words, I would like the cell to return a
DATE that equals 40 weeks prior to 1/25/04. Can you help
me to write it this way?

Thanks again!
Click to expand...
 
Back
Top