calculating days
NETWORKDAYS excludes weekends. Subtracting the earlier date from the
later date should yield the number of days: strange that you're getting
the #Value. Are your dates in serial format? Serial format is Excel's
way of handling dates: each day is an integer value. Today, Jan 26
2006, is 38743: you can check this by formatting the date cell as an
integer.
|