Try
=(A1+60)-DAY(A1+60)+1
This is a discussion on How to calculate "first of the month after 60 days" within the Excel Questions forums, part of the Question Forums category; Hello, I am having trouble creating a formula to capture the "first of the month after 60 days" from the ...
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?
Thanks in advance!
- Radio
Try
=(A1+60)-DAY(A1+60)+1
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
=date(year(A1+60),month(A1+60)+1,1)
Strike that last, misunderstood slightly..
par's got the right answer.
Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac
The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.
Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
Ferris Bueller A.K.A. John Hughes, 1986
Here's one way with hire date in A1
=EOMONTH(A1+59,0)+1
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
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
Radio
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?
Got it, the 03/02 start date would be 06/01.
Like this thread? Share it with others