A number of days into weeks and days

=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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>