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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date dif
No need for datedif here
=IF(A1="","",IF(TODAY()-A130,"OVERDUE","")) -- Regards, Peo Sjoblom Portland, Oregon "jj33002" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date dif
Works great. Thanks for the help. -- jj33002 ------------------------------------------------------------------------ jj33002's Profile: http://www.excelforum.com/member.php...o&userid=30020 View this thread: http://www.excelforum.com/showthread...hreadid=508586 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date dif
I think I figured out a way to do it. I just set the conditional formatting to change it to a different color when "OVERDUE" appears in the cell. If there is a better way to do it please let me know. If not thanks for the help. -- jj33002 ------------------------------------------------------------------------ jj33002's Profile: http://www.excelforum.com/member.php...o&userid=30020 View this thread: http://www.excelforum.com/showthread...hreadid=508586 |
Reply |
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 |