Showing results for 
Search instead for 
Did you mean: 
RitaWK Regular Visitor
Regular Visitor

Get Networking Days in Real time

I need to calculate working days between a start and end day but it must be real time- meaning I have set up reporting periods that have a static start and end day and need to get the real time networking days between that set of days to calculate the current labor cost per employee.   I have a reporting period date table, holiday date table but don't know how to write a real time measure to calculate the networking days - minus weekends and holidays.


Community Support Team
Community Support Team

Re: Get Networking Days in Real time

Hi @RitaWK ,

Please check if the similar thread could help you firstly.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,



Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RitaWK Regular Visitor
Regular Visitor

Re: Get Networking Days in Real time

Here is the table for reporting periods.   So I need a dynamic real time calculation of working days.  If am a user looking at my labor costs on April 15th - then I need to get the current working days for Q2 minus weekends.   I haven't set up a massive table by day to do the calculations of day.   I am hoping you can do a calculation like in Excel where based on the current day it will calculate the correct networkings days real-time.   

Doing it by day counting like in the example, how would I keep that table up to date for real-time.  It seems that would only be helpful if dates are in the past not present.

Report Q IDReporting Period NameQuarterYearStart DateEnd Date
1Q1 2019Q1201912/31/20183/29/2019
2Q2 2019Q220194/1/20196/28/2019
3Q3 2019Q320197/1/20199/27/2019
4Q4 2019Q420199/30/201912/27/2019
5Q1 2020Q1202012/30/20193/27/2020

Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 285 members 3,493 guests
Please welcome our newest community members: