First day of Next Month

  • Thread starter Thread starter Jim
  • Start date Start date
J

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.
 
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.
 
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.
Click to expand...

One of a few ideas:

=EOMONTH(A1,0)+1

= = = = = = =
HTH :>)
Dana DeLouis
 
Back
Top