Target dates to submit reports

[Salamullah]

Target dates excluding holidays (Fri & Sat) of each month to put through formula in plan sheet to get reports from different people, please help me to make a formula in each month based on work days (WKD)

Report WKD Jan Feb Mar ... ....
A 2 2/1/19 4/2/19 4/3/19 ... ....
B 4 6/1/19 6/2/19 6/3/19 ... ....
C 9 13/1/19 13/2/19 13/3/19 ... ....

I have downloaded Calendar Template from excel and wanted to apply formula from it.

 

[Salamullah]

Hi Yes that's what I was looking for, excellent !! many thanks.

a little more modification required, if not mind, now I have a list of annual holidays how can we incorporatesuppose Sun & Mon 2^nd and 3^rd Jun is public holidays,similarly in other month as per the list.

 

[sergioMabres]

Hi Salamullah,
Yes it is possible to detect holidays with formulas, please look now if that is what you need, look in https://1drv.ms/x/s!AovCE1fDrrdSmFJcN0k8fUc3G5UE
The formula is getting very complex, the formula now is

 =IF(WEEKDAY(EDATE($A3,B$1))=7,WORKDAY.INTL(EDATE($A3,B$1),2,7,$O$2:$O$14),IF(WEEKDAY(EDATE($A3,B$1))=6,WORKDAY.INTL(EDATE($A3,B$1),2,7,$O$2:$O$14),WORKDAY.INTL(EDATE($A3,B$1)-1,1,1,$O$2:$O$14)))

In the formula and in the sheet you will see the range $O$2:$O$14, that is the range for holidays, if you need more holiday dates replace the 01/01/2001 to the holiday date you need, the holiday date must have a year 2019 for this test sheet.
If you want the holiday range somewhere else you will have to change the formulas, replace $O$2:$O$14 with the range where the holiday list is.
The main problem with this exercise is that seems to be a triple (Friday, Saturday and Sunday) non-working weekdays and the Excel function WORKDAY.INTL supports only singles and doubles, so it has to be done by IF or you can try doing it with WORKDAY.INTL(WORKDAY.INTL(…))
I hope this is what you needed.
Cheers
Sergio