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
|