Excel problem - weeks and days

  Dirty Dick 17:03 07 Nov 2010
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 2010

Try

B1 = weeks =INT(A1/7)

C1 = days =A1-(B1*7)

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?