Hi

Remain in seme thread


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Mark" wrote in message
...
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

Validation!! Formula!! Macro??
 

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