Create a calculated column to diplay midpoint between 2 dates

Question

Any help greatly appreciated. I'm using SharePoint 2010, typical TASK LIST. I want to put in a start date and a a due date but have a field (column) that displays the MID WAY POINT between those two dates. Thanks Valerie

Answer 1

Create a calculated column and set the fomula to this:

=[Start Date]+ROUND(DATEDIF([Start Date],[Due Date],"d")/2,0)

This gets the difference between the 2 dates and divides by 2, rounds to the nearest integer, then adds the result to the start date.

Here is a reference to formulas you can use in a calculated column:

http://msdn.microsoft.com/en-us/library/bb862071.aspx

Answer 2

An alternative formula for @Laurie's Calculated column suggestion would be:

=AVERAGE([Start Date],[Due Date])