Find Date between two dates

B

Brijesh

In Excel, how do i write a function without macro to find date between two
defined dates.
I have been able to do this for MONTH, but not able to do it for a specific
date.
Please can some one suggest a solution
 
J

Jacob Skaria

Brijesh

Can you define "find date between two defined dates." with an example..

If this post helps click Yes
 
E

Erik

This might work:



Date 1 Date 2 Middle date
01.01.2009 04.04.2009 16.02.2009
=(date1-date2)/2+date1



/Erik
 
Top