HI everyone,
I know that excel can do just about everything, but I don't know if what I want to do is even possible. I am making up a register at work for customer orders, in one column I have the day it was distributed and in another the day it was invoiced. What I want to know is how long it took to complete. This I can figure out easy by having cell 1 - cell 2. My question is: Is it possible for excel to work out how many days in there are weekend and then take them off the total number of days??? Crazy I know. We need to be able to print up a report with all our customer orders on it showing the amount of days it took to complete but not including weekends.
Hope this isn't too far fetched.
Any help would be great.
Thanks
Trish
Bookmarks