I have a worksheet with columns for Transaction Date, Due Date, Past Due 30
days & Past Due 60 days. I would like Excel to say "Yes" if the transaction
date is blank and today's date less the due date is greater than 30 days.
Here is what I build: =IF($B14=""+AND(NOW()-$C1430),"YES","NO"). I accepts
the formula, however I get the #VALUE! message. I hope someone can tell me
what I am doing wrong.

=IF(AND(ISBLANK(B14),TODAY()-C1430),"YES","NO")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dale" wrote:

I have a worksheet with columns for Transaction Date, Due Date, Past Due 30
days & Past Due 60 days. I would like Excel to say "Yes" if the transaction
date is blank and today's date less the due date is greater than 30 days.
Here is what I build: =IF($B14=""+AND(NOW()-$C1430),"YES","NO"). I accepts
the formula, however I get the #VALUE! message. I hope someone can tell me
what I am doing wrong.

Thanks Dave...that worked great.

"Dave F" wrote:

=IF(AND(ISBLANK(B14),TODAY()-C1430),"YES","NO")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dale" wrote:

I have a worksheet with columns for Transaction Date, Due Date, Past Due 30
days & Past Due 60 days. I would like Excel to say "Yes" if the transaction
date is blank and today's date less the due date is greater than 30 days.
Here is what I build: =IF($B14=""+AND(NOW()-$C1430),"YES","NO"). I accepts
the formula, however I get the #VALUE! message. I hope someone can tell me
what I am doing wrong.