Formula Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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()-$C14>30),"YES","NO"). I accepts
the formula, however I get the #VALUE! message. I hope someone can tell me
what I am doing wrong.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formmating - formulas 1
Excel Excel due and overdue date colours 2
Aging Formula 5
Formula not reading date format 3
Need help with access expression - HELP!! 0
conditional formula with date 6
Conditional Formatting – Due Date, Warning - Completion 1
Conditional Formatting – Due Date, Warning - Completion 1

Back
Top