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.

Hi there!

To get the first day of the next month based on the date in A1, you can use the following formula in B1:

Let me break down the formula for you:

1. YEAR(A1) gets the year of the date in A1
2. MONTH(A1)+1 gets the month of the date in A1, adds 1 to it to get the next month
3. 1 represents the first day of the month

So, the formula combines these three arguments to give you the first day of the next month.

For example, if A1 contains 3/10/10, the formula will return 4/1/10 in B1.

I hope that helps! Let me know if you need any further assistance.

Here's another one...

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

Format as Date

--
Biff
Microsoft Excel MVP


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

That may not work for all dates.

The easiest example is January 31, 2010.



"T. Valko" wrote:

Here's another one...

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

Format as Date

--
Biff
Microsoft Excel MVP

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

--

Dave Peterson

On 3/16/2010 8:18 PM, Jim wrote:
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

Ooops!

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

Disregard that formula!

--
Biff
Microsoft Excel MVP


"Dave Peterson" wrote in message
...
That may not work for all dates.

The easiest example is January 31, 2010.



"T. Valko" wrote:

Here's another one...

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

Format as Date

--
Biff
Microsoft Excel MVP

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

--

Dave Peterson