|
|
|
|
#1
06-30-2017, 10:16 AM
|
|||
|
|||
Ok adding that as formula to cell itself worked however could you expand on how to create and statement to include if cell is blank? Thats way i dont get a False statement in there if no date is in other cell
Currently its either up to date or past due but if there is no date entered in source cell it defaults to past due 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula, Compare two cell's text and based on results output a number
|
Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
| Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
|
Creating formula based on if data is correct in cell
|
MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |
| Is there a way to do this? (automatically enter text based on form data) | TIKKI555 | Word | 0 | 05-26-2010 09:21 AM |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode