On Thursday, April 9, 2015 at 1:35:31 PM UTC+5:30,
benwi...@googlemail.com wrote:
" If these dates were public holidays then the real start/end date is a day later/earlier and in any case I'm struggling to work it out otherwise".
Mike's formula is great, but having issue when start date is a public holiday, does anyone know how to resolve this?
Thank you.
=(NETWORKDAYS.INTL(B5,C5,11)-2)*(B2-B1)+(B2-MOD(B5,1))+(MOD(C5,1)-B1)
use this formula to clear your query if you need to add office holidays then add Holiday list in networkdays formula
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)