networkdays

I am wondering,

is there a formula in which i can do the following...
A1 is the finish date
B1 is hours worked per day(same every day)
C1 is Estimated hours to complete.
D1 is Start date. (Location of formula)

this is what i need, (A1-(C1/B1)) - - - (jan27 - (10/5)) = jan 25

I need a date to be the answer...but i need it to ignore weekend dates. That is my sticking point. So if there are weekend date then i need the start date to be further back, to compensate for days that aren't worked(Weekends).

any help is appreciated!

-Boss73

Try the following...

=WORKDAY(A1,-C1/B1)

You'll need to make sure that you've enabled the Analysis ToolPak add-in...

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!

Originally Posted by Boss73

I am wondering,

is there a formula in which i can do the following...
A1 is the finish date
B1 is hours worked per day(same every day)
C1 is Estimated hours to complete.
D1 is Start date. (Location of formula)

this is what i need, (A1-(C1/B1)) - - - (jan27 - (10/5)) = jan 25

I need a date to be the answer...but i need it to ignore weekend dates. That is my sticking point. So if there are weekend date then i need the start date to be further back, to compensate for days that aren't worked(Weekends).

any help is appreciated!

-Boss73