Networkdays question

C

C Tate

I am trying to count the number of workdays between two dates. I seem to
have the analysis toolpack installed. I have put the two dates into a1 and
a2 but the result, in a3, seems to turn out as a long minus number! What am
I doing wrong?
 
D

David Biddulph

So did you put the numbers in the right way round? The first argument
should be the start date, and the second number the end date.
Also, are you sure that Excel is reading both cells as dates (and not text,
or anything else strange)? Look at =A1 and =A2 formatted as numbers to see
whether they seem to be in the right ballbark. [Today is 39143 if you are
working in the 1900 date system.]
 
Top