+ Reply to Thread
Results 1 to 3 of 3

I would like to create a formula based on a specific date, 1st of the month following 60 d

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    florida
    MS-Off Ver
    10
    Posts
    1

    I would like to create a formula based on a specific date, 1st of the month following 60 d

    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.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: I would like to create a formula based on a specific date, 1st of the month following

    Insurance date:
    =EOMONTH(B2+60,0)+1
    For the 401K calc:
    =IF(MONTH(B2)>=6,DATEVALUE("1/1/"&YEAR(B2)+1),DATEVALUE("6/1/"&YEAR(B2)))
    where B2 is the date (I was playing around with a little model to verify it works).
    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.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,086

    Re: I would like to create a formula based on a specific date, 1st of the month following

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF Statement that populates a Month based off of specific Date Ranges
    By cmorten82 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-12-2014, 11:37 AM
  2. [SOLVED] Formula assistance needed to sum data based on anniversary date and month date
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 11:18 PM
  3. Formula to Show Accounting Month based on a specific date range
    By michelle saluta in forum Excel General
    Replies: 1
    Last Post: 09-23-2010, 02:17 PM
  4. formula to generate month-to-date based on auto date
    By infinitysales in forum Excel General
    Replies: 1
    Last Post: 06-27-2008, 01:09 AM
  5. Replies: 3
    Last Post: 09-25-2007, 10:26 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1