How to get last working date excluding holidays from reload time?

[#1]

Consider a reload time is 11/02/2013(Saturday). And holiday date is 11/04/2013(Monday) So according to this scenario last working date should be 11/01/2013(Friday) And if there is holiday on 11/01/2013(Friday) as well as on 11/04/2013(Monday) then last working date should be  10/31/2013(Thursday).

I tried with LastWorkDate() function but it gives me next working date i used below format

LastWorkDate('11/02/2013',1,'11/04/2013')

It gives me 11/05/2013 but i want 11/01/2013.

i also tried

LastWorkDate('11/02/2013',-1,'11/04/2013') but its not working

Please help??????

[swuehl · Accepted solution]

Use FirstWorkDate() instead.

FirstWorkDate('11/02/2013',1,'11/04/2013')

[Clever_Anjos]

You shoult try =FirstWorkDate('11/02/2013',1,'11/04/2013')