Date Function

A

AJ

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.
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top