How to calculate the day before last two working day of each month? e.g.,
28th of June, 27th of July, 29th of August, 28th of Sept...?
How to calculate the day before last two working day of each month? e.g.,
28th of June, 27th of July, 29th of August, 28th of Sept...?
On Wed, 29 Jun 2005 01:20:01 -0700, "Angus" <[email protected]>
wrote:
>How to calculate the day before last two working day of each month? e.g.,
>28th of June, 27th of July, 29th of August, 28th of Sept...?
With any date in the month of interest in A1:
=workday(DATE(YEAR(A1),MONTH(A1)+1,1),-2)-1
If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.
On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks