Date dif

[jj33002]

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.

 

[Peo Sjoblom]

No need for datedif here

=IF(A1="","",IF(TODAY()-A1>30,"OVERDUE",""))

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[jj33002]

Works great. Thanks for the help.

 

[jj33002]

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.