Hi, I would like to know if i can add another formula (add on) to below function i'm currently using.



For example a date is entered on A09 cell, the next cell A10 will reflect either 'Open' or 'Closed' by using this formula =IF(AO9="","Open","Closed").

Now beside this, I also need to know if I can add another formula next to it.
Cell A09 requires a date to be entered in order to know my document is Open or Closed, but by 7 days if there isn't any date entered i want my cell A10 to show 'Due' by number of days.

Great if anyone can help

Attached Files

Testing.xls (71.0 KB, 12 views)

A10 is in another record and contains another date. The formula you are citing is in AR9.

I believe this is what you are trying to do in AP9 (again, not A10). Your formula does not work if there is no Date Received i.e. still Open. If I understand correctly, this is what you want:

=IF(ISBLANK(AO9),TODAY()-AM9,MAX(AO9-AM9,0))

If there is a Receive Date, the formula gives the number of days late. If received on time, the formula returns zero. If there is no Receive Date, the formula gives the number of days currently late (i.e. if it is still not received tomorrow, it will increment by one).

Thank you gebobs. Appreciate it very much