Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Data Validation Formula Help | Excel Worksheet Functions |