Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
recently i resolve same type of issue with the help of interval match.
=
date(rangesum(MinDate,MaxDate)/2)
Superb - thanks very much !! 🙂