Hi Bob,

That works and just makes too much sense! I kept reading all the posts about
calculating dates and was making it too complicated.

I appreciate the help.

Anne, thanks for your help also.

Christine


"Bob Phillips" wrote:

Uh, maybe

=B3 - B6*7

--
HTH

Bob Phillips

"Christine" wrote in message
...
I've seen several postings on this but all of them seem much more
complicated
than what I'm looking for. Hopefully someone can help.

I have a spredsheet that contains a Start Date.

I have several tasks that have to be done on a specified # of weeks (could
change to days if easier) before that start date.

I tried using =(Weekday) but can't seem to make it work. I entered
=WEEKDAY(B3-
B6) - my start date is in B3 and formatted as a date, and the # of days
before that date is entered in B6.

Does that make any sense to anyone?

Thanks for your help

Christine