Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

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

share|improve this answer
    
Thanks, Laurie. that sounds like just what I wanted. I'll check out the link too. –  user3320 May 12 '11 at 16:47

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

=AVERAGE([Start Date],[Due Date])
share|improve this answer
    
Nice. I didn't realize you could use average on dates. –  Laurie May 9 '11 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. –  Stuart Pegg May 9 '11 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 Feb 9 '12 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. –  Stuart Pegg Feb 9 '12 at 20:34

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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