I have a date in D2 and have a formula to compute the due date at the end of the following month less one days. For eg if date in D2 is 31/07/2015 (dd/mm/yyy) , the funds to be paid 30/08/2015
I would like to amend my formula to exclude weekends and public holidays
It would be appreciated if someone could kindly assist me
Code:
="Funds to to be paid "&TEXT(EOMONTH(D2,1)-1,"dd/mm/yyyy")&""
I would like to amend my formula to exclude weekends and public holidays
It would be appreciated if someone could kindly assist me