C
Coy Bruner
I WENT TO THE WEBSITE
http://www.cpearson.com/excel/datedif.htm
TO SHOW ME HOW TO BUILD A SCHEDULING APPLICATION.
I TYPED IN THE FIRST EXAMPLE IT SHOWED.
AND IT SAID THAT I HAD A CIRCULAR REFERENCE.
WHAT CELLS DO I TYPE IN FOR THIS WORKSHEET, AND WHICH WILL BE DRAGGE
AND COPIED?
THE FORMULA IS:
=MAX(0,NETWORKDAYS(MAX(D$5,$B6),MIN(DATE(YEAR(D$5),MONTH(D$5)+1,0),$C6))
http://www.cpearson.com/excel/datedif.htm
TO SHOW ME HOW TO BUILD A SCHEDULING APPLICATION.
I TYPED IN THE FIRST EXAMPLE IT SHOWED.
AND IT SAID THAT I HAD A CIRCULAR REFERENCE.
WHAT CELLS DO I TYPE IN FOR THIS WORKSHEET, AND WHICH WILL BE DRAGGE
AND COPIED?
THE FORMULA IS:
=MAX(0,NETWORKDAYS(MAX(D$5,$B6),MIN(DATE(YEAR(D$5),MONTH(D$5)+1,0),$C6))