software

I have one interesting question

I have one sheet = sheet1

A1 = (input date) would be: 01 of any month (something like
01.01.2006)
A2 = would be the last date in the month, the same month as in A1

Does anyone know the formula for this ??--
alen_re
------------------------------------------------------------------------
alen_re's Profile: www.excelforum.com/member.php...oamp;userid=28331
View this thread: www.excelforum.com/showthread...hreadid=504824
The simplest way is to use

=EOMONTH(A1,0)

EOMONTH is part of Analysis ToolPak addin

an alternative is

=DATE(YEAR(A1),MONTH(A1) 1,0)

for both format cell as date--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=504824On Wed, 25 Jan 2006 04:10:49 -0600, alen_re
gt; wrote:

gt;
gt;I have one interesting question
gt;
gt;I have one sheet = sheet1
gt;
gt;A1 = (input date) would be: 01 of any month (something like
gt;01.01.2006)
gt;A2 = would be the last date in the month, the same month as in A1
gt;
gt;Does anyone know the formula for this ??

Another alternative would be:

=A1 32-DAY(A1 32)--ron