"Dave O" wrote in message
oups.com...
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.


Only his calculation cells need to be in number format so they make sense to
the viewer. The dates used for calculation can remain in normal date format.