Thanks:  0
Likes:  0

# Thread: How to calculate "first of the month after 60 days"

1. ## How to calculate "first of the month after 60 days"

Hello,
I am having trouble creating a formula to capture the "first of the month after 60 days" from the Hire Date.
Example, Hire Date is 01/15/2013, should return 04/01/2013. Would the ROUNDUP function be useful here?

2. ## Re: How to calculate "first of the month after 60 days"

Try

=(A1+60)-DAY(A1+60)+1

3. ## Re: How to calculate "first of the month after 60 days"

=date(year(A1+60),month(A1+60)+1,1)

4. ## Re: How to calculate "first of the month after 60 days"

Strike that last, misunderstood slightly..

5. ## Re: How to calculate "first of the month after 60 days"

Here's one way with hire date in A1

=EOMONTH(A1+59,0)+1

6. ## Re: How to calculate "first of the month after 60 days"

Hi, Thanks for the quick response. The formula gave me one month prior, meaning 03/01/13 for the 01/15/2013 start date. So I tried it with 90 days, =(A1+90)-DAY(A1+90)+1 and it worked! This is cool and will help me track eligibility. Thanks for your help

7. ## Re: How to calculate "first of the month after 60 days"

Hello,
I tried all suggestions and they worked! Thanks so much. It's neat how you can solve something a few different ways, I like that about Excel.
I really appreciate the help

8. ## Re: How to calculate "first of the month after 60 days"

Barry's is good but as I understand these types of eligibility it really should be =EOMONTH(A1+60,0)+1

The question is when does the eligibility start for somebody that starts on 3/2? Is it 5/1 or 6/1?

9. ## Re: How to calculate "first of the month after 60 days"

Got it, the 03/02 start date would be 06/01.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•