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

H

hurds999

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

Ron Coderre

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)
 
H

hurds999

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

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

Similar Threads

How to set formula for poping up the date of next Wednesday.... 2
Advancing date to the first of next month? 3
Formula to Return the next 1st Tuesday of a Month 42
2 dimensional date sort 1
Count based on multiple criteria 2
How can i set a formula which shows 2nd last Monday of the month? 5
Rounding date field up to next first of month, with existing formu 5
Date lists 3

Top