Thread: First date of next month?

I have a cell where I put a date A1. I need a formula where it will
produce the first date of the next month.


Thanks for any help.

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


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200507/1

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

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Randy" <ranmcc@msn.com> wrote in message
news:1120838674.526979.259580@o13g2000cwo.googlegroups.com...
> I have a cell where I put a date A1. I need a formula where it will
> produce the first date of the next month.
>
>
> Thanks for any help.
>

Try this:
=EOMONTH(A1,0)+1

Note: If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in

Does that help?

--
Regards,
Ron


"Randy" wrote:

> I have a cell where I put a date A1. I need a formula where it will
> produce the first date of the next month.
>
>
> Thanks for any help.
>
>

Worked great thanks...........

Thanks for the feedback, Randy
I'm glad "=EOMONTH(A1,0)+1" worked for you.

--
Regards,
Ron


"Randy" wrote:

> Worked great thanks...........
>
>