I have one interesting question :D

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 :D ??


--
alen_re
------------------------------------------------------------------------
alen_re's Profile: http://www.excelforum.com/member.php...o&userid=28331
View this thread: http://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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504824

On Wed, 25 Jan 2006 04:10:49 -0600, alen_re
wrote:


I have one interesting question :D

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 :D ??

Another alternative would be:

=A1+32-DAY(A1+32)


--ron