I have following Data.
srno days for drilling days for rolling days for welding Date for drilling Date for rolling Date for welding date for Dispatch
1 0.89 2 0.35 29th Oct 2013
2 1 0.66 7 29th Oct 2013
I already have a Dispatch date for the job. I also have days required to complete activites such as Drilling , Rollling And Welding.
So What i want to do is calculate date for welding , rolling and drilling in backward position.
But i want to ignore weekends i.e. Saturdays and Sundays.
I also want to ignore Vacations/Holidays.i.e. Suppose i have a official holiday on say 28th Oct 2013.
So my RESULT TABLE LOOKS LIKE THIS.
Sr NO days for drilling days for rolling days for welding Date For Drillling Date for rolling Date for welding Date for Dispatch
1 .89 2 .35 23rd Oct 2013 24th Oct 2013 29th Oct 2013 29th Oct 2013
2 1 0.66 7 15th Oct 2013 16th Oct 2013 17th Oct 2013 29th Oct 2013
I am using formulae
=workday(date for dispatch,rows(same row:same row),(ref to list of holidays)-days required
This is not working. NEED HELP.
Bookmarks