Networkdays excluding holidays, need to drag results down a column

[curly22]

I am using the formula for calculating Networkdays, excluding holidays, for 1 column of start dates and 1 columns of end dates, but when I drag the formula down to calculate for the rest of the cells, the cells in which I have the holidays linked in the formula also drag as well. They just eventually move to blank cells! How do I stop that from happening?
Hope that makes sense, thank you for your help!

 

[stan423321]

It sounds like you didn't use dollar signs to "pin" the holidays.

Can you post the "networkday" formula?

 

[curly22]

It sounds like you didn't use dollar signs to "pin" the holidays.

Can you post the "networkday" formula?

Where shall I put the dollar signs?

=DATEDIF(1,NETWORKDAYS(A1,B1,F1:F13),"D")

A=start date
B=end date
F=holiday dates

Thanks!

 

[stan423321]

Replace F1:F13 with $F$1:$F$13 and tell us if it helped.

 

[curly22]

Replace F1:F13 with $F$1:$F$13 and tell us if it helped.

Yes! Thank you!!!