Hi All,

Appreciate if anyone out there can help me on a formula on dates. I have an excel(attached) with 3 columns as below. Im trying to get Column C to calculate the days remaining from column B (B2-Now()) and if column D shows as Delivered then it should show as Done. Im having 3 problems as below:

Test File.xlsx

1) My formula in Column C cannot calculate more than 30 days.
2) Unable to map if Column C is Expired and Column D is Delivered then Column C should show as Done instead of ExpiredDone.
3) Is there anyway to calculate in Column C if column B shows value as Q2, 2016 instead of mmmm dd,yyyy

Yes it is very complicating to me and for the life of me I cannot think of another way to make this work. :-(

Kind Regards,
Mark.