Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??????
Use FirstWorkDate() instead.
FirstWorkDate('11/02/2013',1,'11/04/2013')
Use FirstWorkDate() instead.
FirstWorkDate('11/02/2013',1,'11/04/2013')
You shoult try =FirstWorkDate('11/02/2013',1,'11/04/2013')