Hi

a couple of questions - how are you entering the value in D2 - when it
0406 - is is text or a custom number format? (to test type =isnumber(D2) in
E2 and let me know if it returns True or False).
Additionally, will the duration ever exceed 52 weeks.

Cheers
JulieD

"appeng" wrote in message
...
I work with a schedule that is based on weeks in a year, for example, 0605.
This would be the sixth week of 2005. I need to schedule backwards based
on
an end date 0406.
I know the end date, 4505 or 0406 (may be in cell D1 and D2).
I know the duration, for example 10 weeks and 12 weeks (may be in cell C1
and C2).
What I am looking for help is a formula for how to find a start date.

Cell D1 = 4505
Cell C1 = 10
Cell B1 = 3505 (what is the formula to get this).

Cell D2 = 0406
Cell C2 = 12
Cell B2 = 4405 (what is the formula to get this).

I deal with about 100 to 150 of these in each spreadsheet.

I am using MS Excel 97