Forum Discussion
Median formula according to selected dates
What formula do I have to put into F2 (and F7, F12, F17 respectively) in order to find... - Median of the First Reply (excluding 'null' results) - The data F2 refers to is in accordance with ...
Do you mean by "median" that you want to calculate the date in the middle between the two dates in B2 and B3?
If so, the formula to put in F2 is =B2+((B3-B2)/2)
If not, please come back and clarify. ideally by posting your actual spreadsheet, not just an image of it.