| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date dif
I have a formula that i put in each cell in column B to look at the date in column A. If the date in column A is more than 30 days previous then the cell beside it in column B shows "OVERDUE". If it is not then the cell in column B is left blank. The problem that I am having is that if there is no date in column A then it still shows "OVERDUE". Is there any way to prevent this? Here is the formula that I am using. =IF(DATEDIF(A1,TODAY(),"d")30,"OVERDUE","") If anyone could help i woild appreciate it. -- jj33002 ------------------------------------------------------------------------ jj33002's Profile: http://www.excelforum.com/member.php...o&userid=30020 View this thread: http://www.excelforum.com/showthread...hreadid=508586 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
Threaded Mode
