fill between two date according to working day and non working day , holidays

Hello
i would like to fill in column C date between two date A2, B2 with consideration to Working day is only
Sunday
Monday
Tuesday
Wednesday
and non working day which not need in this interval
Saturday
Thursday
Friday

and holiday In column G

by formula or VBA code

In C2:
=IF(WEEKDAY(WORKDAY.INTL(A2,1,7,$G$2:$G$14))=5,WORKDAY.INTL(A2,2,7,$G$2:$G$14),WORKDAY.INTL(A2,1,7,$G$2:$G$14))

C3 on ward.
=IF(C2<$B$2,IF(WEEKDAY(WORKDAY.INTL($C2,1,7,$G$2:$G$14))=5,WORKDAY.INTL($C2,2,7,$G$2:$G$14),WORKDAY.INTL($C2,1,7,$G$2:$G$14)),"")

See attached.

Try

=IF(C2<$B$2,WORKDAY.INTL($C2,1,"0001110",$G$2:$G$14),"")

@JohnTopley
Ah! Forgot that you can use string to flag weekend in WORKDAY.INTL() function.

what mean by 0001110
and 1 also after $C2, that can i modify it

please can explain your formula

"0001110"
MON, TUE, WED, THU, FRI, SAT, SUN = 0 is workday, 1 is weekend

So in this case, flags THU, FRI & SAT as weekend in WORKDAY.INTL() formula

"0001110" corresponds to Monday to Sunday with 0 = workday, 1 =non-workday

Note your current C2 ignores the fact that 2nd january is a holiday so you should use the WORKDAY.INTL here.

Dear Ck76 can explain your formula

Dear Johntopley
what about first day after starting day C2 what is the formula

My formula is just the long way of doing things. It checks if WORKDAY.INTL result is Thursday using WEEKDAY() function and if true, then looks for next workday.

Use JohnTopley's formula.

C2:
=WORKDAY.INTL(A2,1,"0001110",$G$2:$G$14)

please look to my attached file that want to list date missed from column C in Column D and calculate number of this date in E2
this from start date and end date

Missed Day count

=(B2-A2+1)-COUNT(C3:C120)


=185

Missing dates

in D3

IFERROR(SMALL(IF(COUNTIF($C$3:$C$121,ROW($42005:$42307))=0,ROW($42005:$42307),""),ROWS($1:1)),"")

Enter with Ctrl+Shift+Enter

42005= 1st jan 2015 (in Excel date)

42307= 30th October

I don't know what "missed date" means but you already have the formula for calculating working days, excluding holidays.

Please see my attached file
in column F is the data is missed from column E , this data is working day for me it's consider not have any activity
but column E is working day which have activity
for this i want to know what the date not have activity and list it in column F
hope you are now understand what i mean