Assistance With Embedded If Statement

Originally Posted by Sambo kid

this looks like it would work for you...
=IF(C2<>"",IF(OR(C2="open",C2="pending delivery checks",C2="working on",C2="on hold"),INT((TODAY()-$F2)/7)&" weeks "&MOD(TODAY()-$F2,7)&" days",IF($K2<>"",INT(($K2-$F2)/7)&" weeks "&MOD($K2-$F2,7)&" days","N/A")),"")

You sir, are a saint. Thank you +rep