LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 21st 08, 12:28 PM posted to microsoft.public.excel.links
external usenet poster
First recorded activity by ExcelBanter: May 2008
Posts: 7
Default Setting up an Excel sheet to automatically determine when an employeeshould enter a retirement plan, perhaps What-If Analysis would help? Anyother suggestions?

Perhaps a What-If analysis would help with this, but the situation
that presents itself:

For retirement plans, usually a person must work one year of 1,000
hours before that person can enter into the retirement plan as a
participant. However, plans usually have set dates of entry, usually
twice during the year. Therefore, a person enters on one of those
entry dates subsequent to his attainment of 1,000 hours worked during
a one year period. So, for a plan that functions according to a
calendar year (January 1st to December 31st), the dual entry dates
amount to July 1st and January 1st (the day after the end of the six
month of the year and the day after the twelfth month of the year).

So, a person hired on August 1, 2007 who works 1,000 hours would enter
the plan on January 1, 2009 (since August 1, 2008 marks the one year
anniversary of this person's date of hire, and provided that the
person worked enough hours to attain entry into the plan between
August 1, 2007 and August 1, 2008, January 1st would serve as the
first entry date possible).

Some plans get set up sufficiently generous to allow for a slight
retroactive admission (e.g., if a person hired on August 1st, 2007
works 1,000 hours from then to August 1, 2008, that person
retroactively enters the plan on July 1st, 2008). I hope to receive
responses with suggestions on how to set a file in Excel to
automatically gauge both date of entry for plans with normal entry and
slightly retroactive entry. What formulas or macros in Excel can
anyone suggest to accomplish this?

__________________________________________________ __________________________
The person who created this file and asked me to work on it created
this set of guide information.

Date of Hire plus one year nearest date of either July 1 or January 1
For example DOH Aug 1, 2007 Date of Enty will be January 1 2008*
*Though the person who gave me this file included this hypothetical
case in his description, I feel that he may have erred here, since it
seems to me that the person would enter the plan on January 1, 2009.
For example DOH June 1, 2007 Date of Entry will be July 1 2008

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to set excel at the default setting for the enter key? sternface Excel Discussion (Misc queries) 2 July 14th 06 05:56 PM
How do i set up a sheet to count the years to retirement? dee29 Excel Worksheet Functions 1 April 6th 06 11:55 AM
schedule plan for every 3 month in one sheet excel jameela Charts and Charting in Excel 1 February 14th 06 11:29 AM
How do I determine automatically that a sheet is empty? [email protected] Excel Worksheet Functions 4 May 9th 05 08:15 PM

All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017