Calculating Workdays?

[kerry78]

Hi,


I am trying to create a "calculator" of Workdays, or as known in m
business, KVM Days.
My issue is this: if my project starts (KVM Day 0) on a weekend o
holiday, the next available business day will ALSO be considered KV
day 0
Cant figure out formula?????
(weekends and holidays are not counted as KVM Days)
Example: start saturday sept 4 (kvm day 0)
sunday sept 5 (kvm day 0)
monday sept 6 (kvm day 0)
tuesday sept 7 (kvm day 0)
wed sept 8 (kvm day 1)
tuesday (kvm day 2) etc.......
See attached sheet : Cell C5 should have a formula that gives result o
07-09-2004- something to the effect of "If startdate falls on weekend o
holiday, then result should be next available business day"
Any insights appreciated!!! Thanks...

:confused

Attachment filename: automatic kvm calculator.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66672

 

[Gary Brown]

Go to 'Tools' then 'Addins' then check the 'Analysis
Toolpak'. Now the 'Workday' function is available for use.
HTH,
Gary

 

[Robert Humiston]

Try a variation of this. Paste this into your field (adjust the cells)
=IF(D10>F10,SIGN(NETWORKDAYS(D10,F10)),ABS(NETWORKDAYS(D10,F10))-(1))

 

[kerry78]

I am trying to use the formula....but get the following: ######## an
then a num error....

D10 and F10 are supposed to represent what?/ which cells?

Thanks!
kerr

 

[kerry78]

Should I make a column with all weekend dates in 2004-2005?

That way i could use this formula in cell C5: if B5 (thats my star
date) is equal to a weekend or holiday (O5:O15) then add one day

??????
Or is there a more simple way without pulling out my calender ?