display a number as weeks and days?

Originally Posted by daddylonglegs

With the NETWORKDAYS formula in C1 you could use this formula for weeks

=INT(C1/5)

and for days

=MOD(C1,5)

If you want you could cut out the intermediate step and put your NETWORKDAYS formula directly into the weeks and days, e.g.

=INT(NETWORKDAYS(A1,B1)/5)

and

=MOD(NETWORKDAYS(A1,B1),5)

Spot On

Thank You.