date

[vinod9111]

Hi all,


got small problem, what to add to 30/9/2008 to get 31/10/2008 and to 31/10/2008 to get 30/11/2008.

thanx for your time.

 

[c_m]

=eomonth(A1,1)
where A1 = 31/10/2008
similarly for the other one

 

[vinod9111]

Thanx cm for the reply, but getting the error <TABLE style="WIDTH: 61pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=81 border=0 x:str><COLGROUP><COL style="WIDTH: 61pt; mso-width-source: userset; mso-width-alt: 2592" width=81><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl22 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 61pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=middle width=81 height=20 x:err="#NAME?">#NAME?</TD></TR></TBODY></TABLE>

 

[c_m]

goto Tools>>Addins>>select analysis Tool pack

 

[sanrv1f]

try

=A1+32-DAY(A1+31)

 

[sanrv1f]

sorry wrong formula, pls ignore

 

[vinod9111]

any other ideas, analysis took pack not installed