Whoops . . . On Wed, Apr 23, 2008 at 5:35 PM, Adrian Try <[EMAIL PROTECTED]> wrote:
> It should always be possible to work out a formula without using complex > functions. The fun is, working out how! > And getting it wrong can be fun too. Not. Sorry, I was interrupted towards the end of figuring that formula out, and forgot something important. This one should work *all the time*: =(YEAR(B1)-YEAR(A1))-IF(MONTH(B1)=MONTH(A1);DAY(B1)<DAY(A1);MONTH(B1)<MONTH(A1)) Adrian
