Quote:
Originally Posted by Kevin@Radstock
Perhaps something along the lines of the attached file.
|
thanks for that, it does indeed look good, just to confirm that it will include saturday and sundays and allow me to exclude only the dates that i want?
what i currently have is
=NETWORKDAYS(C7,C8,B2:B5)+(TEXT(C8,"HH:MM")-TEXT(C7,"HH:MM"))-1
however this just does monday/friday and excludes saturday and sundays anyway which i do not want it to do