New User,
1. I am creating a Dashboard with average weeks and days. I am using this formula to calculate the average amount days. For Example, 145 days is shown in cell G9 as a result of the formula below:
=IFERROR(AVERAGEIFS(Curt_T[DURATION(DAYS)],Curt_T[STAGE],"Adopted Technology",Curt_T[CLOSED],"CLOSED"),"")
The I am using this formula to calculate amount of Weeks and Days left over.
=INT((G9)/7)&" weeks"&IF(MOD(G9,7)=0,"",", "&MOD(G9,7)&" days")
The formula is producing 20 weeks and 4.666666666666666 days. I need my formula to round down to 4 days. I am in Sales and I love excel but I am working with limited knowledge. This is my first time posting to a forum like this.
Thanks in advance,
CB
Bookmarks