I would like to create a formula based on a specific date, to return a date 1st of the month following 60 days. and then another for 401k eligibilty based on a specific date 1 yr after hire date to return a value January 1 or July 1, whichever is closest based on when eligible? Thank you inadvance forum for all your help.
Insurance date:
For the 401K calc:
=EOMONTH(B2+60,0)+1
where B2 is the date (I was playing around with a little model to verify it works).=IF(MONTH(B2)>=6,DATEVALUE("1/1/"&YEAR(B2)+1),DATEVALUE("6/1/"&YEAR(B2)))
Also, yes, it IS annoying trying to determine when your insurance will kick in after a new hire
Last edited by mikeTRON; 03-06-2015 at 03:50 PM.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks