Estimated date of completion
 

I am trying to predict an estimated date for complete
depletion of an inventory number based on a current rate
of reduction that could vary from day to day. I'm using:

=WORKDAY(TODAY(),(C12/C30),Holidays)

Could I get some ideas as to why this formula gave me
about a month difference in one day with no change in the
inventory numbers?

Holidays range is:
12/27/2004
12/28/2004
1/3/2005
3/25/2005
3/28/2005
C12 is the number 3178 (initial base amount)
C30 is the number 19 (current daily rate of reduction from
C12)

Yesterday the formula resulted in June 29, 2005 today it
gave me July 25, 2005.

Any help will be appreciated!

Make sure that when entering a start date (other than when using the
TODAY() function) that the date is enclosed within quotes...

=WORKDAY("11/25/2004",C12/C30,Holidays)

Hope this helps!

Anderson Wrote:
I am trying to predict an estimated date for complete
depletion of an inventory number based on a current rate
of reduction that could vary from day to day. I'm using:

=WORKDAY(TODAY(),(C12/C30),Holidays)

Could I get some ideas as to why this formula gave me
about a month difference in one day with no change in the
inventory numbers?

Holidays range is:
12/27/2004
12/28/2004
1/3/2005
3/25/2005
3/28/2005
C12 is the number 3178 (initial base amount)
C30 is the number 19 (current daily rate of reduction from
C12)

Yesterday the formula resulted in June 29, 2005 today it
gave me July 25, 2005.

Any help will be appreciated!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=320581