Rounding a date up to the 1st of the next month
 

I have a date in A1, but I need to populate A2 with the first day of the
following month. Example: A1 = 05/17/08, A2=06/01/08

What formula would best work to accomplish this? I'm guessing this would be
easy, but I can't get anything to work.

Thank you in advance for any assistance.

Rounding a date up to the 1st of the next month
 

If you have the Analysis ToolPak add-in installed:
A2: =EOMONTH(A1,0)+1

If you don't....
A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"hurds999" wrote in message
...
I have a date in A1, but I need to populate A2 with the first day of the
following month. Example: A1 = 05/17/08, A2=06/01/08

What formula would best work to accomplish this? I'm guessing this would
be
easy, but I can't get anything to work.

Thank you in advance for any assistance.

Rounding a date up to the 1st of the next month
 

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

--
Gary''s Student - gsnu200777

Rounding a date up to the 1st of the next month
 

Thank you both very very much. The formula(s) worked!! You're both very
awesome!!! Have a great Wednesday, because you've made mine!!! =)


"Ron Coderre" wrote:

If you have the Analysis ToolPak add-in installed:
A2: =EOMONTH(A1,0)+1

If you don't....
A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"hurds999" wrote in message
...
I have a date in A1, but I need to populate A2 with the first day of the
following month. Example: A1 = 05/17/08, A2=06/01/08

What formula would best work to accomplish this? I'm guessing this would
be
easy, but I can't get anything to work.

Thank you in advance for any assistance.

Rounding a date up to the 1st of the next month
 

You're very welcome.

Regards,

Ron
Microsoft MVP (Excel)
"hurds999" wrote in message
...
Thank you both very very much. The formula(s) worked!! You're both very
awesome!!! Have a great Wednesday, because you've made mine!!! =)


"Ron Coderre" wrote:

If you have the Analysis ToolPak add-in installed:
A2: =EOMONTH(A1,0)+1

If you don't....
A2: =DATE(YEAR(A1),MONTH(A1)+1,0)+1

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"hurds999" wrote in message
...
I have a date in A1, but I need to populate A2 with the first day of the
following month. Example: A1 = 05/17/08, A2=06/01/08

What formula would best work to accomplish this? I'm guessing this
would
be
easy, but I can't get anything to work.

Thank you in advance for any assistance.