formulas based on a date

[atmbonda]

Hello,

In cell A1, I have a date, say, May 10, 2003
In cell B1, I want to input a formula so that it returns the first of the
following month, in this case June 1, 2003

If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003
in cell B1

Please help me out - Thanks

Al M.

[Don Guillett]

with analysis toolpak addin installed
=EOMONTH(E1,0)+1

--
Don Guillett
SalesAid Software
[email protected]
"atmbonda" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> In cell A1, I have a date, say, May 10, 2003
> In cell B1, I want to input a formula so that it returns the first of the
> following month, in this case June 1, 2003
>
> If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1,
2003
> in cell B1
>
> Please help me out - Thanks
>
> Al M.

[Ron de Bruin]

Try this

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"atmbonda" <[email protected]> wrote in message news:[email protected]...
> Hello,
>
> In cell A1, I have a date, say, May 10, 2003
> In cell B1, I want to input a formula so that it returns the first of the
> following month, in this case June 1, 2003
>
> If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003
> in cell B1
>
> Please help me out - Thanks
>
> Al M.

[atmbonda]

Thanks, I tried and it worked. Thanks again.

Al Mb.

"Don Guillett" wrote:

> with analysis toolpak addin installed
> =EOMONTH(E1,0)+1
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "atmbonda" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > In cell A1, I have a date, say, May 10, 2003
> > In cell B1, I want to input a formula so that it returns the first of the
> > following month, in this case June 1, 2003
> >
> > If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1,
> 2003
> > in cell B1
> >
> > Please help me out - Thanks
> >
> > Al M.
>
>
>

[atmbonda]

Thanks, I tried and it worked. Thanks again.

Al Mb.

"Ron de Bruin" wrote:

> Try this
>
> =DATE(YEAR(A1),MONTH(A1)+1,1)
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "atmbonda" <[email protected]> wrote in message news:[email protected]...
> > Hello,
> >
> > In cell A1, I have a date, say, May 10, 2003
> > In cell B1, I want to input a formula so that it returns the first of the
> > following month, in this case June 1, 2003
> >
> > If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003
> > in cell B1
> >
> > Please help me out - Thanks
> >
> > Al M.
>
>
>