NetworkDays problem!

[Karahs]

Hello everyone,

Having NetworkDays with same Start Date and End Date gives Value as 1 i want it as 0,

Tried using if(start date=end date,0,networkdays(Startdate,enddate)) Still Giving output as 1...y is it so??

Thanks&Regards

[vinieme12 · Accepted solution]

Does your start date and end date also have time stamps?

try this instead

= if(FLOOR(NUM(start date))=FLOOR(NUM(end date)),0,networkdays(Startdate,enddate))

[Karahs]

Hello Vineeth ,

Thankyou it worked .

[vinieme12]

Happy to help

Cheers

V