Maybe...DATEDIF

[texastomass]

Hi,

In A1 i have 01/01/2011 and in c1 i have 01/12/2011 , i would like b1 to display the date which is exactly half way between the two dates ?

Thanks

 

[VoG]

One way

=(A1+C1)/2

Format as Date.