Formula to show "Yes" if paid, "No" if not

A

Amanda

Please does anybody know a formula that will show me "Yes" or "No" whether
an invoice has been paid with 21 days or not.

Based on invoice date in B7 and invoice paid date in J7, can this also show
a "No" if there is nothing in invoice paid date in J7.

Any help apprecieated
Trudy
 
R

RagDyeR

=IF(AND(J7<>"",J7-21<B7),"YES","NO")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Please does anybody know a formula that will show me "Yes" or "No" whether
an invoice has been paid with 21 days or not.

Based on invoice date in B7 and invoice paid date in J7, can this also show
a "No" if there is nothing in invoice paid date in J7.

Any help apprecieated
Trudy
 

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

If, And Or 2
Auto Change Formulas - Please Help. 2
Making data in appear in one worksheet from another 2
Conditional formatting with multiple formula 2
IF(AND problem to work out commissions 7
saveas macro help 1
Invoicing and customer database 0
How to add values in one column based on values in another column 6

Top