Need help on calc. on 2 dates

[#1]

Hi.

Im struggling with a problem that i need to get the numbers of days (and later on hours) between 2 dates

My code for now:

First try:

if ("Date_1" > "Date_2",networkdays("Date_1", "Date_2", '13-04-2017','14-04-2017','17-04-2017','12-05-2017','25-05-2017','05-06-2017')-1,0) as Numbers_of_days,

second try:

    if ("Date_1" > "Date_2", NetWorkDays("Date_1", "Date_2", '13-04-2017','14-04-2017','17-04-2017','12-05-2017','25-05-2017','05-06-2017')) as Numbers_of_days,

First try give only eiter a - or 0 while second gives 0 or -1

who can help me ??

[sunny_talwar · Accepted solution]

I think since Date_2 is smaller, it seems like it should be the first argument here. May be this:

NetWorkDays("Date_2", "Date_1", '13-04-2017','14-04-2017','17-04-2017','12-05-2017','25-05-2017','05-06-2017')

Look here for NetWorkDays

[#3]

Thx.. It worked and you where right..