Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a expression how to calculate the working day in month.
Example:
April- 23
May- 3 (as of today three working days)
If I see tomorrow it should display as
April -23
May-4 (if i see tomorrow four working days)
How can I achieve it can any body help me?
regards,
Yoganantha Prakash G P
Something like
=NetWorkDays(Monthstart(today()), today() )
Let's assume you have a flag field like [Working day]:
1. 1 - stands for working day
2. 0 - it 's not a working day
Then try this:
Sum({<Date = {"<=$(=Today())"}>} [Working day])
As dimension use [Year, month]
What defines a workday? Monday to Friday? and do you have a list of holidays you would want to exclude?
Monday to Friday only Sunny
Something like
=NetWorkDays(Monthstart(today()), today() )
Then use the networkingday() function
networkdays (start:date, end_date {, holiday})
Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.
Examples:
networkdays ('2007-02-19', '2007-03-01') returns 9
networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8
thanks stefan
networkdays(monthstart(today()), today)