First day of Next Month

[Jim]

Hello,

In A1 I have the date 3/10/10.

In B1 I would like to insert a formula that will show the Date 4/1/10.

Basically, I would like a formula that will show the first of the next month
no matter what date is shown in A1.

Thanks for the help.

 

[RagDyeR]

Try this:

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

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hello,

In A1 I have the date 3/10/10.

In B1 I would like to insert a formula that will show the Date 4/1/10.

Basically, I would like a formula that will show the first of the next month
no matter what date is shown in A1.

Thanks for the help.

 

[T. Valko]

Here's another one...

=A1+31-DAY(A1+31)+1

Format as Date

 

[Dave Peterson]

That may not work for all dates.

The easiest example is January 31, 2010.

 

[Dana DeLouis]

Hello,

In A1 I have the date 3/10/10.

In B1 I would like to insert a formula that will show the Date 4/1/10.

Basically, I would like a formula that will show the first of the next month
no matter what date is shown in A1.

Thanks for the help.

One of a few ideas:

=EOMONTH(A1,0)+1

= = = = = = =
HTH :>)
Dana DeLouis

 

[T. Valko]

Ooops!

Yeah, you're right. Don't know what I was thinking of.

Disregard that formula!