Date difference in WEEKS

[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!

 

[Paul]

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!

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)

 

[Marcy]

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!

 

[Peo Sjoblom]

=A1-40*7

--

Regards,

Peo Sjoblom

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!

 

[Marcy]

THANK YOU a thousand times over!!

-----Original Message-----
=A1-40*7

--

Regards,

Peo Sjoblom





.