When an assignment comes in that date is
entered into a cell. we also have have a cell to place the date the work is completed, the date it is returned to us by e-mail, and the date it is sent back to our customer. What I would like to do is to setup
the cell with the date showing when it was returned to change color it this was over 10 business days past due. We do not count weekends in the time promised.
thanks Paddy for replying,
waynetrim
entered into a cell. we also have have a cell to place the date the work is completed, the date it is returned to us by e-mail, and the date it is sent back to our customer. What I would like to do is to setup
the cell with the date showing when it was returned to change color it this was over 10 business days past due. We do not count weekends in the time promised.
thanks Paddy for replying,
waynetrim