formulas based on a date
 

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.

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

--
Don Guillett
SalesAid Software

"atmbonda" wrote in message
...
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.

Try this

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

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


"atmbonda" wrote in message ...
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.

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

"atmbonda" wrote in message
...
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.

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" wrote in message ...
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.

formulas based on a date
 

Where in your formula below would I indicate I want the last day of the six
month post the date put in the indicated Cell? Thank you for your assistance.
--
Judy Rose Cohen


"Ron de Bruin" wrote:

Try this

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

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


"atmbonda" wrote in message ...
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.