Hello all,
Can someone help in defining a VBA variable which will return a date which will be the first working date of the last month. So for example, today's date is 01/06/2015 but I want the variable to return based on today's date the first working day of last month which is 01/05/2015 which was a Friday.
many thanks in advance
Can someone help in defining a VBA variable which will return a date which will be the first working date of the last month. So for example, today's date is 01/06/2015 but I want the variable to return based on today's date the first working day of last month which is 01/05/2015 which was a Friday.
many thanks in advance