Forum

For those interested, I ended up with this formula, which did the trick. Days left =IFERROR(IF([@Status2]=Lists!$C$3,NETWORKDAYS.INTL(TODAY(),[@...

Figured it out, but took a while to execute. However, wondering if there is an easier method? Using Text to columns, I split the range into a lower...

Thanks Mynda. I have tried this before; however, because we are using it to text/sms, it defeats the purpose when we upload to csv file to Vodafone...