Dates

[Boss73]

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

[daniels012]

I think one of these should help in what your looking for:


If January 7, 1998, and January 8, 1998, are holidays, then:
WORKDAY(DATEVALUE("01/03/1998"),5,{35802,35803}) equals 35808 or January 13, 1998.

The following example returns the number of workdays for a project that begins on October 1, 1999, and ends on February 15, 2000; it excludes December 24, 1999, and January 3, 2000.
NETWORKDAYS("10/01/1999",
"2/15/2000",{"12/24/1999","1/3/2000"}) equals 96

Michael