Unlike dates in days

[warrentk80]

Goodmorning everyone,

I need to calculate a date difference in days and not solar. (thus excluding Saturdays and Sundays)

the next step I should do is to calculate the difference between two data considering also the end time working and not of 24 h.

someone would know to give me directions?

Thanks for collaboration

Andrea

[ahmar811]

can you upload some simple excel or .qvw file

[hic]

Check the function Networkdays()

HIC

[miguelbraga]

Hi Andrea,

I've done something similar to this and found an interesting post on the community that you can follow to get what you need. Please check the following threads:

function:networkday

Networkdays function to change non working days from saturday-sunday to thursday-friday

NetWorkDays

Regards,

MB

[miguelbraga]

You can do it using this function:

=NetWorkDays([Your Start Date], [Your End Date],$(vPublicHolidays))

Which vPublicHolidays you can assign the holydays days like the following example:

'01/01/2013','01/04/2013','06/05/2013','25/12/2013','26/08/2013','26/12/2013','27/05/2013','29/03/2013'

Hope this is what you're looking for

[warrentk80]

Thanks for the answer, in the attached file. I would like to calculate difference in the script and not of the dashboard.

Available for clarification

Thank you

Andrea

[miguelbraga]

Check my binary qvw please: