How to calculate a 'middle date' from 2 other dates ? Help please :-)

[#1]

Hi,

I have a table like this..

Item A Delivery from 01/01/10 Delivery to 01/02/10

I am looking for some thing script wise that would give me the 'mid date' i.e 15/01/10

Was thinking convert date to numbers, then ((MAX DATE - MIN DATE) / 2) + MIN DATE & then convert number back date, but

a) not sure if this is the best approach and

b) can't find the function to convert dates to numbers

Any ideas please - help gratefully received 🙂

Thanks

Bob

[suniljain]

recently i resolve same type of issue with the help of interval match.

[#3 · Accepted solution]

=

date(rangesum(MinDate,MaxDate)/2)

[#4]

Superb - thanks very much !! 🙂