Date = first day of next month

[Dylan @ UAFC]

in
A B
1/19/2088 2/1/2008
2/20/2008 3/1/2008
1/23/2008 2/1/2008
What formula can I use in the B column to make this
happen

 

[Bob Phillips]

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

 

[Glenn]

in
A B
1/19/2088 2/1/2008
2/20/2008 3/1/2008
1/23/2008 2/1/2008
What formula can I use in the B column to make this
happen

There are several options. Try this one:

=DATE(Year(A1),MONTH(A1)+1,1)

 

[Ron de Bruin]

hi Dylan

You can use this

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

 

[T. Valko]

Try one of these.

If you have the Analysis ToolPak add-in installed...

=EOMONTH(A1,0)+1

Format as Date

Or:

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