A number of days into weeks and days
 

Hi

Taking date of the 5-8-2005 from 30-8-2005 then dividing the answer by 7
gives 3.571429.......weeks.
How do you convert the decimal part of 0.571429 into number of days?. i.e. 4
Can an Excel formula give the correct answer of 3 weeks 4 days.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro

=INT((H1-G1)/7)&" weeks"&IF(MOD(H1-G1,7)=0,"",", "&MOD(H1-G1,7)&" days")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Robert Christie" wrote in message
...
Hi

Taking date of the 5-8-2005 from 30-8-2005 then dividing the answer by 7
gives 3.571429.......weeks.
How do you convert the decimal part of 0.571429 into number of days?. i.e.
4
Can an Excel formula give the correct answer of 3 weeks 4 days.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro

=INT(3.571429)
will give you 3 weeks

=(3.571429-INT(3.571429))*7
will give you 4 days

Replace 3.571429 with your formula

Mangesh





"Robert Christie" wrote in message
...
Hi

Taking date of the 5-8-2005 from 30-8-2005 then dividing the answer by 7
gives 3.571429.......weeks.
How do you convert the decimal part of 0.571429 into number of days?. i.e.
4
Can an Excel formula give the correct answer of 3 weeks 4 days.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro

=mod(enddate - startsdate,7) will give the number of days.

so

=INT((enddate-startdate)/7)&" weeks "&MOD(enddate-startdate,7)&" days"

returns

3 weeks 4 days


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=400393

Thank you Bob, Mangesh and Alex for your quick replies.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro


"Bob Phillips" wrote:

=INT((H1-G1)/7)&" weeks"&IF(MOD(H1-G1,7)=0,"",", "&MOD(H1-G1,7)&" days")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Robert Christie" wrote in message
...
Hi

Taking date of the 5-8-2005 from 30-8-2005 then dividing the answer by 7
gives 3.571429.......weeks.
How do you convert the decimal part of 0.571429 into number of days?. i.e.
4
Can an Excel formula give the correct answer of 3 weeks 4 days.
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro