software

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 quot;OVERDUEquot;. 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 quot;OVERDUEquot;. Is
there any way to prevent this? Here is the formula that I am using.

=IF(DATEDIF(A1,TODAY(),quot;dquot;)gt;30,quot;OVERDUEquot;,quot;quot;)

If anyone could help i woild appreciate it.--
jj33002
------------------------------------------------------------------------
jj33002's Profile: www.excelforum.com/member.php...oamp;userid=30020
View this thread: www.excelforum.com/showthread...hreadid=508586No need for datedif here

=IF(A1=quot;quot;,quot;quot;,IF(TODAY()-A1gt;30,quot;OVERDUEquot;,quot;quot;))

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;jj33002quot; gt; wrote in
message ...
gt;
gt; I have a formula that i put in each cell in column B to look at the date
gt; in column A. If the date in column A is more than 30 days previous then
gt; the cell beside it in column B shows quot;OVERDUEquot;. If it is not then the
gt; cell in column B is left blank. The problem that I am having is that
gt; if there is no date in column A then it still shows quot;OVERDUEquot;. Is
gt; there any way to prevent this? Here is the formula that I am using.
gt;
gt; =IF(DATEDIF(A1,TODAY(),quot;dquot;)gt;30,quot;OVERDUEquot;,quot;quot;)
gt;
gt; If anyone could help i woild appreciate it.
gt;
gt;
gt; --
gt; jj33002
gt; ------------------------------------------------------------------------
gt; jj33002's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30020
gt; View this thread: www.excelforum.com/showthread...hreadid=508586
gt;
Works great. Thanks for the help.--
jj33002
------------------------------------------------------------------------
jj33002's Profile: www.excelforum.com/member.php...oamp;userid=30020
View this thread: www.excelforum.com/showthread...hreadid=508586
I think I figured out a way to do it. I just set the conditional
formatting to change it to a different color when quot;OVERDUEquot; 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: www.excelforum.com/member.php...oamp;userid=30020
View this thread: www.excelforum.com/showthread...hreadid=508586