=A2-105 where A2 is the deadline date.
BTW, I make that 20th June.
--
HTH
Bob Phillips
"Need2Know" wrote in message
oups.com...
Hi all
I wonder if someone can help me with this.
I have to get my designs done 15 weeks (105 days) before the deadline.
For one of my projects my deadline is 3rd Oct
and I want to calculate in 1 cell what day i need to complete the
project - 15 weeks before the deadline but excluding the weekends, can
you help me find a formula for this?
My Deadline is 3rd Oct, i should be completing the project on 28th
June? how can i get excel to calculate the correct completion date?
Thank you for your help
Need2
|