Decimal places

[tmarsh77]

I am using this formula

=TRUNC((E3-D3)/7)&" Weeks and "&MOD(E3-D3,7)&" Days"

to calculate date difference between two dates. It returne too many decimals, e.g.

17 Weeks and 5.5281935185194 Days

I've set the cell to number with no decimal but that doesn't do it.

Thanks.

[rwgrietveld]

Thats because you have made it into a string.

Use the & FORMAT(MOD(E3-D3,7) , "##.##")

EDIT: Note by DO should be & TEXT(MOD(E3-D3,7) , "##.##")

[tmarsh77]

Thats because you have made it into a string.

Use the & FORMAT(MOD(E3-D3,7) , "##.##")

EDIT: Note by DO should be & TEXT(MOD(E3-D3,7) , "##.##")

Excellent! That's it, thanks very much.