First day of each month?

[Ltat42a]

Question....if I were to put 01/01/07 in cell A1, is there a formula available I can put in B1 that would give me 02/01/07, C1 would give 03/01/07 & so forth & so forth???

Thanx

[VBA Noob]

Try

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

and drag across

VBA Noob

[VBA Noob]

Or if you have the Analysis toolpak installed try

=EDATE(A1,1)

VBA Noob

[mudraker]

put date in A1
In B1 put this formula =A1+1
Drag formula across

[VBA Noob]

Mudraker,

That what I posted until I re-read the title

First day of each month

put date in A1
In B1 put this formula =A1+1
Drag formula across

VBA Noob

[Ltat42a]

Nice....Thanx.

LT

[mudraker]

VBA Noob

Yeap Reading titles does help to answer question correctly

[daddylonglegs]

Here's another way.....

=A1+32-DAY(A1+31)

[mdbct]

You can accomplish this without using a formula. Enter your date, do a right click drag across, release and choose "fill months" or "Series..." and choose "Months" in the Date Unit area.