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