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??
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))
Hello Vineeth ,
Thankyou it worked .
Happy to help
Retrieving data ...