+ Reply to Thread
Results 1 to 3 of 3

If statement to calculate 'first of the month following 90 days'

  1. #1
    Registered User
    Join Date
    05-01-2019
    Location
    Jackson, Michigan
    MS-Off Ver
    10
    Posts
    1

    If statement to calculate 'first of the month following 90 days'

    I'd like to write an if statement that basically allows me to use a date of hire and if an employee is benefit eligible, then calculate when they would become eligible.
    ie: Employee is hired 6/12/24 and is eligible for benefits on 10/1/24. How do I write that if statement?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: If statement to calculate 'first of the month following 90 days'

    With the date in A2,
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Or, for example:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: If statement to calculate 'first of the month following 90 days'

    Thanks for the rep.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Calculate days needed from month to month
    By Pierre2024 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-21-2024, 12:59 PM
  2. [SOLVED] calculate no. of days if every month has 30 days
    By sanjuss2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-30-2021, 04:15 AM
  3. [SOLVED] Need formula to calculate days used in month initiated in previous and selected month
    By Ochimus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2021, 05:54 AM
  4. Replies: 2
    Last Post: 04-20-2020, 01:30 PM
  5. [SOLVED] Formula to calculate working days and calendar days per month-year ?
    By donny007 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2018, 06:23 PM
  6. [SOLVED] calculate the number of days in a month through 'Month Name'
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2017, 03:10 PM
  7. [SOLVED] Calculate Uptime in Days within the constraint of Total Days in Each Month
    By jchungerford in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-29-2017, 06:54 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