Re: Open Office vs. Excel - dates

["Jerry Feldman-2" <user=4@nabble.blu.org>]

 On Mon, 19 Nov 2007 16:09:42 -0500 
Tom Metro <[hidden email]> wrote: 

> Jerry Feldman wrote: 
> > A1 = 06/04/2002 
> > B1 = 07/04/2007 
> > B2 = =DATE(YEAR(B2); MONTH(B2) + 1; DAY(B2)) 
> > Replicated down through B69 
> 
> Shouldn't that be: 
> B2 = =DATE(YEAR(B1); MONTH(B1) + 1; DAY(B1)) 
> 
> Assuming the intent was to start with 07/04/2007 and increment by one month. 
> 
> 
> > C2 = =YEARS($A$2;$B2;0) 
> > Replicated down through C69 
> > 
> > In Excel, the formula in C2 (and following) is: 
> > C2 = =DATEDIF($A$2;$B2;"y") 
> 
> I'm not following precisely what you're trying to do as you didn't 
> define what was in A2, but try: