<< SharePointAce Consulting Group is now being aggregated on Planet SharePoint! | Microsoft continues to improve the Mac client experience on hosted Exchange/SharePoint >>

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:

Related posts

SharePoint List Calculated Column - Calculate Business DaysCalculated column trick to determine weekdays for any list column of type DateTime.SharePoint Designer Workflow – Send Email Reminder X days prior to a Date Business Problem One of my clients wanted to send email reminders to users one week prior to ...Calculated Columns - Displaying ImagesRecently, I was working on a project that required the creation of an IT Project Management Si...

Comments

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

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]