Re: Date(Y,M,D) 'feature' or problem?
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Wed, 16 Nov 2005 10:13:24 -0500
On Wed, 16 Nov 2005 05:44:40 -0800, "Jon McP"
<JonMcP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>In the Date function if you take 31/03/2007 and add 1 month to it:
>=DATE(YEAR(ref),MONTH(ref)+1,DAY(ref))
>you get 01/05/2007, which really isn't 1 month later. Bug or feature?
Feature.
It translates 31 April 2007 to a real date, which can be very useful in certain
circumstances. Including using the 0th day of the month to indicate the last
day of the previous month.
If you want to adjust so as not to "run over", look at HELP for the EDATE
work*** function (requires the analysis tool pak).
--ron
.
- Prev by Date: Re: How to repair 2005-2006 student attendance record?
- Next by Date: Re: formula that will go up one space if no value in specified space
- Previous by thread: Re: Date(Y,M,D) 'feature' or problem?
- Next by thread: Re: How to project usage.
- Index(es):
