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

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

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

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