|
|
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.
|