Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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
Cheers
V