Results 1 to 6 of 6

Calculating eligibility based on date

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2016
    Location
    California
    MS-Off Ver
    2007
    Posts
    43

    Calculating eligibility based on date

    Hello,
    I'm trying to determine when an employee will be eligible for the 401k program. Employees can enroll after "First of the Month Following" 90 days of employment. I was looking to use a function that would allow me to fill out a cell with the exact date.

    Example: if John Doe is hired on 3/2/2021, he's eligible to enroll in the 401k program on 6/1/2021. Enrollments can only occur on the First of the Month. I have attached a sample sheet with one desired result.

    I searched through the database but could not find relevant with the keywords I used.

    Much appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dates Macro. Calculating date based on current date and input date
    By sachin20us in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2018, 09:29 AM
  2. Randomly Select Worker Based On Eligibility (see details inside)
    By levitt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2014, 03:11 PM
  3. [SOLVED] Retirement Eligibility Date based on 3 Variables
    By PacNW in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 10-05-2014, 01:04 PM
  4. Using If/And Function to figure out Eligibility of Benefit at a Future Date
    By alauratag in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2014, 01:44 PM
  5. [SOLVED] Need Help with Formula for Eligibility Result Form based on 2 input Variables
    By jlepp06 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 08:08 AM
  6. [SOLVED] Formula for calculating a new date based on an existing date and other cell criteria
    By scsuflyboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 09:49 AM
  7. Calculating Eligibility Dates & Hiding negative Dates
    By Dooger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2012, 04:01 PM

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