Calculate Business days when weekend is not Sun & Sat in SharePoint sites - InfoPath Dev
in

InfoPath Dev

Calculate Business days when weekend is not Sun & Sat in SharePoint sites

Last post 05-08-2009 10:43 PM by ramakrishna. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 05-08-2009 10:43 PM

    Calculate Business days when weekend is not Sun & Sat in SharePoint sites

    I'm trying to calculate business days between 2 date lists in SharePoint, and I found a formula that works great here: http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_22144390.html =(DATEDIF([Start Date],[Due Date],"D"))-INT(DATEDIF([Start Date],[Due Date],"D")/7)*2-IF((WEEKDAY([Due Date])-WEEKDAY([Start Date]))
    Ram.
Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.