PDA

View Full Version : [SOLVED] IF statments with weekday



Hudson
10-06-2016, 11:57 AM
Hi all,

I was wondering if some one would advice me with below formula.

=IF(WEEKDAY(B13,2)=5,"Friday","" then Date1-Date2 if it is less than <=4 my value should be " TAT met" or els " TAT missed)

attached is the file I can share with you for your reference .

look for example sheet for better understanding .

Thanks in advance !!!!
Hudson

mana
10-07-2016, 10:51 PM
I can't understand.
But i can guess.

=IF(WORKDAY(B2-1,C2)<A2,"TAT not met","TAT met")

Hudson
10-08-2016, 01:15 AM
Hi Mana. thanks a lot for your help on my request .. i got the solution.

it is =IF(NETWORKDAYS(B515,A515)-1<=IF(OR(DAY(B515)<=10,DAY(B515)>20),2,4),"TAT met","TAT not met")

thanks everyone ...