#1
|
|||
|
|||
IF Function
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 |
#2
|
|||
|
|||
Quote:
Quote:
=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). |
#3
|
|||
|
|||
Thank you gebobs. Appreciate it very much
|
Tags |
dates, texts |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What function would do this? | namedujour | Excel | 3 | 09-14-2015 07:15 PM |
#REF! Error in calling VBA function disappears when function is copied | lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
IF function | msheyworth | Excel | 2 | 03-28-2013 02:15 AM |
Sum Function | teza2k06 | Excel | 3 | 02-06-2013 08:29 AM |