Date Function
 

Hello Everyone
I am trying to find a formula that will convert the date in column A to the
1st day of the following month in column B. The formula should be in column B
For example:
Column A Column B
1-Jan-07 1-Feb-07
15-Jan-07 1-Feb-07
31-Jan-07 1-Feb-07
15-Aug-07 1-Sep-07
31-Dec-07 1-Jan-08 and so on.

TIA for any suggestions on a formula.

Date Function
 

Try this:

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

HTH,
Elkar


"AJ" wrote:

Hello Everyone
I am trying to find a formula that will convert the date in column A to the
1st day of the following month in column B. The formula should be in column B
For example:
Column A Column B
1-Jan-07 1-Feb-07
15-Jan-07 1-Feb-07
31-Jan-07 1-Feb-07
15-Aug-07 1-Sep-07
31-Dec-07 1-Jan-08 and so on.

TIA for any suggestions on a formula.

Date Function
 

One way:

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

In article ,
AJ wrote:

Hello Everyone
I am trying to find a formula that will convert the date in column A to the
1st day of the following month in column B. The formula should be in column B
For example:
Column A Column B
1-Jan-07 1-Feb-07
15-Jan-07 1-Feb-07
31-Jan-07 1-Feb-07
15-Aug-07 1-Sep-07
31-Dec-07 1-Jan-08 and so on.

TIA for any suggestions on a formula.

Date Function
 

Try...

B2, copied down:

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

Hope this helps!

In article ,
AJ wrote:

Hello Everyone
I am trying to find a formula that will convert the date in column A to the
1st day of the following month in column B. The formula should be in column B
For example:
Column A Column B
1-Jan-07 1-Feb-07
15-Jan-07 1-Feb-07
31-Jan-07 1-Feb-07
15-Aug-07 1-Sep-07
31-Dec-07 1-Jan-08 and so on.

TIA for any suggestions on a formula.

Date Function
 

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


"AJ" wrote in message
...
Hello Everyone
I am trying to find a formula that will convert the date in column A to
the
1st day of the following month in column B. The formula should be in
column B
For example:
Column A Column B
1-Jan-07 1-Feb-07
15-Jan-07 1-Feb-07
31-Jan-07 1-Feb-07
15-Aug-07 1-Sep-07
31-Dec-07 1-Jan-08 and so on.

TIA for any suggestions on a formula.

Date Function
 

On Mon, 22 Oct 2007 14:58:01 -0700, AJ wrote:

Hello Everyone
I am trying to find a formula that will convert the date in column A to the
1st day of the following month in column B. The formula should be in column B
For example:
Column A Column B
1-Jan-07 1-Feb-07
15-Jan-07 1-Feb-07
31-Jan-07 1-Feb-07
15-Aug-07 1-Sep-07
31-Dec-07 1-Jan-08 and so on.

TIA for any suggestions on a formula.

A slightly different solution than others have written:

=A2-DAY(A2)+33-DAY(A2-DAY(A2)+32)


--ron