INT Formula Not Working Correctly

Hello and welcome to the forum.

The second MOD(G9,7) part is what you need to focus on. Try this:

=ROUNDDOWN(MOD(G9,7),0)

Including that in your formula will give you this:

=INT(G9/7)&" weeks"&IF(MOD(G9,7)=0,"",", "&ROUNDDOWN(MOD(G9,7),0)&" days")

i get 20 weeks and 5 days which is what it should be unless the 145 is not 145 and something like 144.66666

if it is since you are familiar with the int function use it again
=INT((G9)/7)&" weeks"&IF(MOD(G9,7)=0,"",", "&INT(MOD(G9,7))&" days")

Wow! Both of these INT formula solutions worked great. Thank you. I am truly blown away with how fast you both solved my INT formula issue. Nice work. I am greatful.

Best,

CB

Glad we could help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.