Skip to main content

Marshall S's Library tagged development →  View Popular

02 Apr 08

MOSS 2007-Networkdays formula - MSDN Forums

Expression for use in SharePoint calculated column to get number of weekdays between two dates. Has bugs if either date falls on a weekend.

forums.microsoft.com/...ShowPost.aspx - Preview

administration development howto sharepoint






  • SharePoint NETWORKDAYS Formula (for Start and End dates that are Week days)
    =IF(AND((WEEKDAY([End Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([End Date],2)))>1),(((DATEDIF([Start Date],[End Date],"D")+1))-(FLOOR((DATEDIF([Start Date],[End Date],"D")+1)/7,1)*2)-2),(((DATEDIF([Start Date],[End Date],"D")+1))-(FLOOR((DATEDIF([Start Date],[End Date],"D")+1)/7,1)*2)))
    • This is pretty amazing, even with the bugs. It definitely works. - on 2008-04-02
    Add Sticky Note
1 - 20 of 103 Next › Last »
Showing 20▼ items per page

Selected Tags

Related Tags

Sponsored Links

Ads by Google

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo