Originally Posted by
benishiryo
hi zince, welcome to the forum. there are several questions.
1) what is your weekends? Sat & Sun?
2) 9 May 2013 is a Wed. 13 May 2013 is a Mon. So if you consider Sat & Sun as weekends, do you consider it to be 4 or 3 days? because Thu, Fri & Mon are 3 days. and you put it as "yes".
here's how it's roughly going to be. NETWORKDAYS will give you the working days between 2 dates. you can even put in a list of holidays for eg a list of dates in G1:G10
=NETWORKDAYS(A2,C2,$G$1:$G$10)
if you consider the above to be 3 days, then minus 1
=NETWORKDAYS(A2,C2,$G$1:$G$10)-1
so something like this:
=IF(OR(AND(B2<=4,NETWORKDAYS(A2,C2,$G$1:$G$10)-1<=2),AND(B2>4,NETWORKDAYS(A2,C2,$G$1:$G$10)-1<=3)),"Yes","No")
Bookmarks