Validation!! Formula!! Macro??

M

Mark

Hi

My worksheet has the following:-

In Cell B a received invoice date is input
In Cell C a received invoice date at cost center is input
In Cell D the following formula is input to calculate the
number of days =DAYS360(B4,C4)

What I am trying to achieve is if the number of days
calculated is over 15 staff have to issue a late invoice
letter.
So if I could get some sort of message to appear this
will ensure that this is done.

Thanks for your help
 

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

Compile Error. in table-level validation expression in append query 0
Compile error in table level validation expression in ms access office 2019 0
Removing a repeated words 0
VLOOKUP & Data Validation 0
IF validation for time totaling 2
Email? 1
MS Project - error message when checking "Critical tasks" 1
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0

Top