Formula to count days IF the dates fall within the period(start and end date only given)

This is the standard way of getting the number of working days that one date range intersects another:

=NETWORKDAYS(MEDIAN($H$2,$I$2,$A2),MEDIAN($H$2,$I$2,$B2))-1

You just need three of those:

=NETWORKDAYS(MEDIAN($H$2,$I$2,$A2),MEDIAN($H$2,$I$2,$B2))-1
+NETWORKDAYS(MEDIAN($H$3,$I$3,$A2),MEDIAN($H$3,$I$3,$B2))-1
+NETWORKDAYS(MEDIAN($H$4,$I$4,$A2),MEDIAN($H$4,$I$4,$B2))-1

Put that in C2, format the cell as General, then copy down.

NOTE: The Networkdays function takes a third parameter if you wanted to add a list of known holidays to exclude.

You need the stats column to do what? Give some expected results and explain them if it isn't obvious.

That's up to you to decide. NETWORKDAYS usually includes the first date and the second date in the answer. So if you use it give you the NetWORKDAYS that exist between 3/25/2013 and 3/26/2013, it will say 2. That's fine if you wanted to know "how many workdays are in between these two dates."

But funny thing is most of the time that's not exactly how it's being used. Most people want to know "how many have passed between the following two dates." The answer to "how many days have passed between 3/25 and 3/26 is most often 1, so if you use NETWORKDAYS, you'll have to subtract 1 from the result. Most of the time.

Again, it's up to you to decide if the answer is correct by including or excluding that first day.

Originally Posted by angelkulit025

....but when you put 29/4 as the starting date and 20/5 as the end date you will only get 18 days I need to get 20 days. Can we do something about it?thanks again! =)

Using Jerry's suggested formula I get 15 for that example - how did you get 20, which days are you counting?