View Single Post
  #1   Report Post  
Christine
 
Posts: n/a
Default Calculating a date in Excel...

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