# of Selling Days

[lneff]

I'm trying to show how many days left in the quarter and year using NetWorkDays. Its not recognizing the holidays I'm entering. I should show 43 days left in the quarter and its showing 44. 

This is my expression for the quarter:

NetWorkDays(Date(today(),'5/27/2024'),QuarterEnd(Date(today(),'5/27/2024')))

And the year: 

NetWorkDays(Date(today(),'1/01/2024''5/27/2024''7/04/2024''9/02/2024''11/21/2024''11/22/2024''12/25/2024'),YearEnd(Date(today(),'1/01/2024''5/27/2024''7/04/2024''9/02/2024''11/21/2024''11/22/2024''12/25/2024')))

[MatheusC]

Hi, @lneff 

I would work this into the script by bringing in these holidays with a mapping, using either an inline or a table for holidays.
Then you could create a flag and later use it in your application.

See the example below; this is just an example and you can adapt it to your data if you find it useful.

Regarts, Matheus