Calculating a date.

[Chris Berry]

What would be the easiest way to determine an entry date for a retirement plan? The criteria is entry date is the first of the month following the date on which the employee has worked 1 year.

Right now I'm taking the date of hire and:

1. use separate columns to break the date elements out (6/1/06 = 6 1 2006)
2. add a year to determine if they have met the requirement
3. If they have met the requirement, add one to the month and year element from the date of hire and put in "/01/" as the day.

I just saw EDATE and realized that would replace part of my step three, but I don't know how to tell Excel to use 01 as the day without breaking it into elements and concatenating with the month and year elements.

Any help will be appreciated.

Chris

[oldchippy]

What would be the easiest way to determine an entry date for a retirement plan? The criteria is entry date is the first of the month following the date on which the employee has worked 1 year.

Right now I'm taking the date of hire and:

1. use separate columns to break the date elements out (6/1/06 = 6 1 2006)
2. add a year to determine if they have met the requirement
3. If they have met the requirement, add one to the month and year element from the date of hire and put in "/01/" as the day.

I just saw EDATE and realized that would replace part of my step three, but I don't know how to tell Excel to use 01 as the day without breaking it into elements and concatenating with the month and year elements.

Any help will be appreciated.

Chris

Hi Chris,

Start date in A1, formula in A2

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

oldchippy

[Chris Berry]

Wow, talk about cutting out a lot of work!

Thanks a million. I figured there had to be a simpler way.

[oldchippy]

Wow, talk about cutting out a lot of work!

Thanks a million. I figured there had to be a simpler way.

Thanks for the feedback - glad to be of assistance

oldchippy