I'm trying to create a formula to minus one date from the next. So i've done
the standard equation in column d (=c1-b1) and i get my answer. but in some
cases some cells in column b are not filled in. so in column d i get these
really big numbers. i dont want those numbers there so i was wondering how i
get rid of them. also these two things im minusing are dates. i was wondering
if there was any ways to create the formula to only include work week days so
if cell b1 is friday january 4 2008 and c1 is monday january 7 2008. i want
cell d1 to say 1 and not 3. is this possible.

I hope someone can understand this. And any help would be much appreciated.