Calculate the Start date

[lyroj]

hi, i have a wookbook where user enters the end date of a job & it has to calculate the start date by considering the time required (in days) to do the job.
A1=Start date
B1=End date
C1=Time reqd (in days)

i used A1 = B1-C1 , to get the start date.

But i need a formula that does the following.

Start date = End date-(Time rqd + Number of sundays + no of holidays)
plz help.

 

[Sandeep Warrier]

Hi Barry, Thanks for the explanation! I understand the working now. This is a very interesting approach.