Excel problem - weeks and days

  Dirty Dick 17:03 07 Nov 10
Locked

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

DD

  VoG II 17:15 07 Nov 10

Try

B1 = weeks =INT(A1/7)

C1 = days =A1-(B1*7)

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…