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
|