Thanks for that. I assume it counts in the dates given as well so to get a "five working day apart from the day request was taken" I simply put a -1 in at
=SUM(INT((WEEKDAY(A1-{2,3,4,5,6})+B1-A1-1)/7))
It works, and gives me the correct answer, but there's a little green triangle on the top left of the box which gives an "inconsistent formula message", is it ok to just mark it as ignore?
Bookmarks