| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Blank field formatted as date
I am trying to use a function to evaluate when a course is due. In column D
there may or may not be a date listed. I'm using this formula in to evaluate if the course is due to be renewed. =IF(DATE(YEAR(D3)+3,MONTH(D3),DAY(D3))<=TODAY(),"d ue"," ") The problem arises when D3 is blank. It is still evaluating the blank cell as a date, 01/01/1907 and returning "due" because it is less than today. If D3 is blank I need the formula to return an empty string, which I thought the above did. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for latest date | Excel Worksheet Functions | |||
| blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) | |||
| Pivot table will not group a date field | Excel Discussion (Misc queries) | |||
| Validating a date field | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Threaded Mode
