-
Recent Posts
Archives
Categories
- C# Programming
- HTML CSS JavaScript
- Introduction to Sharepoint 2010
- Sharepoint 2010 Branding
- Sharepoint 2010 CAML
- Sharepoint 2010 Central Administration
- Sharepoint 2010 Client Object Model
- Sharepoint 2010 Coding Standards
- Sharepoint 2010 Designer
- Sharepoint 2010 Document Center
- SharePoint 2010 FAQ
- Sharepoint 2010 Fast Search
- Sharepoint 2010 Features
- Sharepoint 2010 Foundation
- Sharepoint 2010 Infopath
- Sharepoint 2010 JQuery
- Sharepoint 2010 LINQ
- Sharepoint 2010 Lists , Libraries & Event Receivers
- Sharepoint 2010 Master Page
- Sharepoint 2010 Meeting Workspace
- Sharepoint 2010 Mobile
- Sharepoint 2010 OutOfTheBox
- Sharepoint 2010 Pages & Navigation
- Sharepoint 2010 Powershell
- Sharepoint 2010 Ribbon
- Sharepoint 2010 Search
- Sharepoint 2010 Security
- Sharepoint 2010 Server Object Model
- Sharepoint 2010 Silverlight
- Sharepoint 2010 Site Collection
- Sharepoint 2010 Site Definition
- Sharepoint 2010 User Profiles
- Sharepoint 2010 Web Parts
- Sharepoint 2010 Webservice
- Sharepoint 2010 Workflow
- Sharepoint 2010 Workspace
- Sharepoint 2010 WPF
- SharePoint 2013 Architect
- SSRS Reports
- Visual Studio 2010
Meta
Category Archives: Sharepoint 2010 OutOfTheBox
Common Date Time formulas for Sharepoint – Calculated Fields
Common Date Time formulas for Sharepoint – Calculated Fields Get Week of the year =DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])),2)+1 First day of the week for a given date: =[Start Date]-WEEKDAY([Start Date])+1 Last day of the week for a … Continue reading
Posted in Sharepoint 2010 OutOfTheBox
Leave a comment