Hi guys,

First, credits to @Jeremy_Oglesby for this awesome workaround. Since I cannot message him directly here, I am hoping that he catches this! Thank you so much for this!!! My coding skills are not good and I have been trying to figure this on my own.

This was his workaround:

IF(


{Months Remaining}>0,


IF(


{Years Remaining}>0,


{Years Remaining}) &


IF(


{Years Remaining}>1, "yrs ",


IF(


{Years Remaining}=1, “yr "


)


) &


({Months Remaining}-{Years Remaining}*12) &


IF(


OR(


({Months Remaining}-{Years Remaining}*12)>1,


({Months Remaining}-{Years Remaining}*12)=0


),


“mos “,


IF(


({Months Remaining}-{Years Remaining}*12)=1,


“mo "


)


),


{Days Remaining} &


IF(


{Days Remaining}>1,” days”,


IF(


{Days Remaining}=1,” day”


)


)


)

I noticed that this only works for combinations of years and months so lets say just for the sake of this example that the remaining duration would be 1 year &; 6 months ; 28 days. Then it will not display the 28 days when using this formula. It wont display 28 days until it goes to a full month which should be then 1 year & 7 months.

Can you give a modified version of this code to include the remaining 28 days?

Anyone’s time would be appreciated! I just cant seem to work on the logic of the code.

Thanks again!