Monday, 10 February 2014

SharePoint: Calculating duration in days

Create a new calculated column with the formula:

=IF(OR(ISBLANK([Start Date]), ISBLANK([End Date])),"",DATEDIF([Start Date],[End Date],"d"))

The outcome will be the number of days difference for [End Date] -[Start Date]

No comments:

Post a Comment