Formula to Count The Number Of Work Days between dates and in in the fiscal month

Looking to calculate the number of workdays that a specific event has in a specific month.

Example:
Event Date Range: 01/10/20 - 02/08/20
Fiscal January: 12/22/20 - 01/21/20

Looking to calculate the number of workdays between 01/10 and 01/21

Answer would be 8

Any help would be greatly appriciated! Thank you!

Please find the example under the link:
filebin.net/uu3ic7df3u9w2vev

(I can not add an attachment to my message. Might be because I am new to the forums)

EDIT: Sorry, I did not understand the problem correctly. Please provide us with some sample workbook.


Regards,
Buskolsky

Hello LCalvert. Welcome to the forum.

The information "Looking to calculate the number of workdays between 01/10 and 01/21" needs to be part of the formula - I could obviously use the the networkdays calc to get it from this point.

There is a structure issue here I am thinking.

I am envisioning a layout (that structure will affect my solution), but I do not know if it is valid.
With that thought in mind please upload an Excel workbook (please no pictures or screenshots) that represents the layout and expected results you envision. The instructions are in the 'gold' banner at the top of the page entitled "HOW TO ATTACH YOUR SAMPLE WORKBOOK:".

Originally Posted by Buskolsky

Please find the example under the link:
filebin.net/uu3ic7df3u9w2vev

(I can not add an attachment to my message. Might be because I am new to the forums)

Regards,
Buskolsky

Welcome to the forum.
You are able to upload files (but not post links at this time). See the instructions at the top of this page in the 'gold' banner HOW TO ATTACH YOUR SAMPLE WORKBOOK:

I did not follow that link. So this may be the same.

In D3 uses the default Sat-Sun weekend.

Formula:

Please Login or Register  to view this content.

	A	B	C	D
1			Fiscal start →	12/22/2019
2	Event Start	Event End	Fiscal end →	1/21/2020
3	1/10/2020	2/8/2020	Workdays →	8