Thanks for the reply, first i should have explained my formula in a little better detail.
On my spreadsheet, Col J is the "Due Date" Col and Col I is the "Date Paid" Col. Col K as you see in the formula (K2*1) is just a col that I stuck the amount owed, in this case $194.00. That formula does work, but if you enter todays date in the "Date Paid" col, the "Paid" col will remains blank. If I change the "Due Date" to 15 Feb, in the "Paid col it will display the value of K2*1 or $194.00. If I leave the "Due Date" as 31 May the "Paid" col will remain blank. I would like for the "Paid' col to display "paid" whatever the date entered in the "Date Paid col.