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
