Suppose you are given a date and you are asked to calculate Previous Working day if date is of weekend. If date is a regular workday, then you should show the same date.
For example – 8-Mar-19 is a working day. Hence, you should show the same date. But if this is either 9-Mar-19 or 10-Mar-19 which are Saturday and Sunday, then you must show 8-Mar-19 as the previous workday.
In this case, formula to be used would be
=WORKDAY(A2+1,-1)
Assuming, your holidays are in E2:E3, then formula would be
=WORKDAY(A2+1,-1,$E$2:$E$3)
That does not work. It always takes away one day.
Can you please give me an example date where it doesn't work?