Calculating dates

A

alen_re

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

daddylonglegs

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
 
R

Ron Rosenfeld

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 ??
Click to expand...

Another alternative would be:

=A1+32-DAY(A1+32)


--ron
 
Top