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
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