NETWORKDAYS vs COUNTIFS

[amberd]

I have a calendar created in Excel and conditional formatting to highlight certain days between 2 separately input dates at the top. On the far right I am wanting to count the number of network days within a row, but ONLY if they are between the "1st day of Leave" and "Last Day" at the top.

I have formulas that show the network days for each row (excluding my holidays), and the number of total days in each row that are included within those dates, but can't figure out how to do both at the same time. Below are the formulas I currently have for those 2 columns (in the January row).

=IF(AF6="",NETWORKDAYS(B6,AE6,'Holiday List'!$A$2:$A$15),NETWORKDAYS(B6,AF6,'Holiday List'!$A$2:$A$15))

=COUNTIFS(B6:AF6,">="&$O$2,B6:AF6,"<="&$Y$3)

 

[dreid1011]

What do you mean by "do both at the same time" ? In the same cell? Or something else? What is the desired result?

 

[amberd]

I figured it out. Below is the formula I used in the January row for anyone else that it can help.

The previous ways counted only network days in the row, OR only ALL days in the row within the 2 dates at the top. The below counts network days within the row, but ONLY if they are within the 2 dates at the top.

=MAX(0,NETWORKDAYS(MAX(B6,$O$2),MIN(DATE(YEAR(B6),MONTH(B6)+1,0),$Y$3),'Holiday List'!$A$2:$A$15))