SharePoint Calculated Column – Calculate Business Days Only, exclude weekends!

by Oscar 7. October 2009 22:14

A while back, I talked about only taking into account business days on any SharePoint Designer workflow or SharePoint List calculated column. It seems to be a very popular post to date (based on Google Analytics Reports), and I thought it would be great to point people to it today!

In case you missed it: http://blogs.sharepointace.com/post/SharePoint-List-Calculated-Column-Calculate-Business-Days.aspx

Regards,
Oscar

Tags:

SharePointAce Consulting Group is now being aggregated on Planet SharePoint!

by Oscar 3. October 2009 17:19

We at SharePointAce Consulting Group are delighted to be part of the vast amount of SharePoint blogs that are being aggregated by Planet SharePoint and look forward to continuing contributing our experience. You can view our profile here

Tags:

Blog | MOSS 2007 | WSS 3.0 | SharePointAce Consulting Group, LLC

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About Oscar

I am a SharePoint Solutions Architect and Managing Partner at SharePointAce Consulting Group, LLC. I have over 13 years of software development experience.

Previously a Consultant at Microsoft Consulting Services (MCS) North West Region with focus on the SharePoint Products and Technologies Platform. I have been involved with SharePoint since it's first version (SharePoint 2001) and have grown more gray hair providing solutions ever since :)

Author of the CQWP – Recurring Calendar Events at http://cqwprce.codeplex.com

Follow me on Twitter.

Contributor to the book:

Occasional Speaker at SharePoint Saturday -

RecentComments

SharePoint 2010 – Current iPhone User Experience (7)
Kim wrote: Checking into a more indepth review into an iPhone… [More]
SharePoint 2010 – Current iPhone User Experience (7)
Ronny Cunningham wrote: Amazing post. There's a lot of good info here, alt… [More]
SharePoint List Calculated Column - Calculate Business Days (22)
Elbio wrote: Can anyone tell me how to calculate a due date whe… [More]
SharePoint 2010 Rich Media – Skinning the MediaPlayer and using it as a Page Field on a Publishing Page (1)
David Martos wrote: Great post! One question, have you tried to show t… [More]
Programmatically add a CSS link on your WebPart (2)
Oscar wrote: Nelson, let me know if you still need help... [More]
Programmatically add a CSS link on your WebPart (2)
Nelson wrote: Hi there Oscar, Very nice post, but I wonder if… [More]
List Event Handler ItemUpdated Event – How to set a form field value programmatically (2)
Oscar wrote: Hi Senthilrajan, You should be able to using a … [More]
SharePoint List Calculated Column - Calculate Business Days (22)
cash loans wrote: Your blog is so informative � keep up the good wor… [More]
SharePoint List Calculated Column - Calculate Business Days (22)
Pop Up Displays wrote: Me and my friend were arguing about an issue simil… [More]
SharePoint List Calculated Column - Calculate Business Days (22)
aion kina wrote: This is the best post on this topic i have ever re… [More]