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