Excel problem - weeks and days

  Dirty Dick 17:03 07 Nov 10

Excel calculation

I'm running Excel 2007 and am struggling with a a formula.

I have a column that adds up the number of days. I then have a formula that calculate weeks (ie A1/7) biu this gives me a decimal figure.

Is there a way I can calculate full weeks and remaing days?

Many Thanx


  VoG II 17:15 07 Nov 10


B1 = weeks =INT(A1/7)

C1 = days =A1-(B1*7)

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5