hi
i need help in creating formula

lets suppose a cell A6 have a date in it. and cell A7 have some number

in cell A8 i want to insert a formula that tell me if A6 have previous date and A7 is empty then A8 show "argent" in red color. if A7 have number then it shows "paid"
if date is today and the A7 is empty then A8 show "Due Today". if A7 have a number then "paid"
if the date is in future then then it shows "due Later"

Thank you