Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
I'm trying to make a Gauge chart , formated as LED display , to give a counter of the date range selected.
So on my page I have a cyclic list box, with date group. I want to write an expression for this LED that states, count days in date range selected
Can anyone help please ?
Thanks
Anne
=NetWorkDays(min(Date),max(Date))
OMG So Sorry , very easy , I'm not the brightest spark in the box!!!!!
Thanks for your help alls good now
=(
max(Date)-min(Date))+1
Hi Guys the above seems to work !!!
But I'd like it to count weekdays only !
Can you please please help ?
Thanks
Hi Anne,
You can use the Network days function which will give the number of working days between start and end date
Hi XXX
I have tried
=NetWorkDays(GetFieldSelections(max(Date)),GetFieldSelections(min(Date)))
As i wish to count the number of work days between my selected dates, but the above is not working ,
Can you please help ?
Thanks
A
=NetWorkDays(min(Date),max(Date))
OMG So Sorry , very easy , I'm not the brightest spark in the box!!!!!
Thanks for your help alls good now