2

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

Improve this question

2 Answers 2

Reset to default
3

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

Improve this answer
1
  • Thanks, Laurie. that sounds like just what I wanted. I'll check out the link too.
    – user3320
    Commented May 12, 2011 at 16:47
2

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

=AVERAGE([Start Date],[Due Date])
Improve this answer
4
  • Nice. I didn't realize you could use average on dates.
    – Laurie
    Commented May 9, 2011 at 14:09
  • @Laurie: I didn't until just a short while ago either. :) I saw your formula and thought: "That looks like an average function. Hmm...". My guess is that it converts the dates to their numeric versions to go through the function and then back again afterwards.
    – Stu Pegg
    Commented May 9, 2011 at 15:35
  • No need to convert, dates are stored as numeric values (number of days). Then they can be rendered as date if you choose date as output format for the calculated column.
    – Christophe
    Commented Feb 9, 2012 at 17:59
  • @Christophe: Fair point, I've seen that this is the case since posting this comment; while dealing with HTMLCC and also with Excel exports.
    – Stu Pegg
    Commented Feb 9, 2012 at 20:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.