#### Bhushan Joshi

##### New Member

I have tried to calculating..

by adding Week "

**N2**=IFERROR(INT((M2-DATE(YEAR(M2),1,1))/7)+1,"")".. post that check

is it even"

**O2**=+ISEVEN(N2)" and then Weekday by"

**P2**=TEXT(M2,"dddd")"..

TAT In days"

**Q2**=IFERROR(+IF(O2&P2="TRUESaturday",+NETWORKDAYS(D2,M2,Master!$G$2:$G$56),+NETWORKDAYS(D2,M2,Master!$G$2:$G$56)-1),"WIP")"

This formula is not working properly as this will fail when there mentioned example:

Eg. If December has 4 Weeks in month & in January there is 5 Weeks in month then 1st week's saturday of February will be non working by this. However this supposed to be Working day.. Need help for concreat solutions.