Re: Calculating dates

Giganews Newsgroups
Subject: Re: Calculating dates
Posted by:  joeu2004 (joeu20…@hotmail.com)
Date: Wed, 5 Jan 2011

On Jan 5, 10:21=A0am, "Rick Rothstein"
<rick.newsNO.S.…@NO.SPAMverizon.net> wrote:
> Another way involving only one function call...
> =3D--TEXT(A5,"m/d/""2010""")

Does not work at all if A5 contains the date 2/29/2008.

See my other response for alternatives for dealing with leap days.

Replies

None

In response to

Re: Calculating dates posted by Rick Rothstein on Wed, 5 Jan 2011