Re: Query
- From: JE McGimpsey <jemcgimpsey@xxxxxxxx>
- Date: Mon, 19 Dec 2005 07:12:30 -0700
Arvi's formula makes an assumption about what you want to happen when
the date in A1 is at the end of the month. It's not that either formula
is wrong, but that since months are rather squirrelly concepts, having
different lengths, adding numbers of months can mean different things to
different folks.
Using the formula you cited, if A1 is 31/1/2005 and A2 is 13, the result
will be 3/3/2006.
Since the 0th day of XL's months are the last day of the previous month,
Arvi's formula gives 28/2/2006.
In article <1135000805.609320.277800@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"Sumit" <sumitagg@xxxxxxxxx> wrote:
> Hi Arvi Laanemets,
>
> I am not able to understand the formula. Mainly why you have used the
> Min formula. Can I use the following part of the formula :
> =DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))
>
> Please give an example to illustrate when the above formula will give
> wrong result and why.
>
> Thanks a lot for taking interest in my query.
.
- Prev by Date: Re: How do I format list of names formatted last,first to first last?
- Next by Date: Re: Query
- Previous by thread: Re: Query
- Next by thread: Re: Query
- Index(es):
Relevant Pages
|
