I am measured by how fast I can move equipment from the time it is received until the time I start processing it and the time I ship it. Equipment comes in every day of the week, but I don't have to start the clock on weekends or holidays until the first workday following its arrival.
My db creates a record when the equipment is checked in.
I used DATEDIF to compare the date received to the date processed and the ship date. However, I have to manually move weekend dates and holidays to the next work date.
Is there a way to create a formula to do this?
My db creates a record when the equipment is checked in.
I used DATEDIF to compare the date received to the date processed and the ship date. However, I have to manually move weekend dates and holidays to the next work date.
Is there a way to create a formula to do this?