excel 2002 convert days to weeks and days

[anon125]

174 days becomes 24.86 days.
how do I make it read 24 weeks and 6 days.
can it be all in one cell?
thanks all

 

[FDibbins]

Try this...
=INT(A1/7)&" weeks and "&MOD(A2,1)*7&" Days"

 

[Momentman]

Like this

Excel 2010
	A	B
1	174	24 weeks and 6 days
Sheet2

Cell Formulas
Range	Formula
B1	=INT(A1/7) & " weeks and " & MOD(A1,7) & " days"

i wonder what the ouput would be with 70 days? 10 weeks and 0 days

 

[anon125]

Like this
Excel 2010

	A	B
1	174	24 weeks and 6 days

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B1 =INT(A1/7) & " weeks and " & MOD(A1,7) & " days" <tbody> </tbody>

<tbody>
</tbody>

i wonder what the ouput would be with 70 days? 10 weeks and 0 days

Thanks for your great help. worked in excel 2002,
and "You can be whatever you think you can" okay, how do I think of being a 25 again and healthy?