There are 20 hours in a work day, i have a start date set. 1/3/05
I know the job will take 120 hours thus it is 6 days. can i set a formula that will ignore weekend dates? So the due date will be 1/10/05 not 1/8/05
The formula i was using was:
A2+(B2/20)
A2 is beginning date
b2 is how many hours
this give me the new date, date + 1 formula....
what cn i do?
-Derek
Bookmarks