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.]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NETWORKDAYS 9
weekdays not using NETWORKDAYS 6
networkdays alternative 2
Date minus work days 8
Calculating days between current date and a date in future NETWORKDAYS() function 2
Networkdays function 3
Workdays/Networkdays #Name? Error 11
Networkdays and misleading results from blank column 3

Top