Results 1 to 6 of 6

Too many IFs - combining few formulas into one - need help

Threaded View

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    57

    Too many IFs - combining few formulas into one - need help

    Hi guys,

    I need help in formulas... I created 6 formulas based on IFs but to be honest I think 1 is possible. In the attachment you can find the 6 formulas, but they are being based on 2 values only.

    I'm trying to make a template for human resource purposes in my company. The formula just needs to calculate number of working days during the month - that's it. Number of working days is simply number of days in the month (no adjustments for holidays or Saturdays, Sundays).

    The two values I mentioned is entry date of an employee and termination date. In order to make a proper calculation one must remember that there are few possibilities:
    - no entry date and no termination date
    - entry date and termination date
    - entry date and no termination date

    And upon those 3 combinations I need to calculate how many working days there are for that particular employee - so if somebody started working last month, and there is no termination date then working days will be simply 28. But if entry date 2nd of february then it will be 27, but if somebody started working on 2nd february and termination date is 27th february then it will be 25 days etc.,

    I would greatly appreciate help ! I think the formulas are working, but having 6 instead of 1 is just super messy. Thanks in advance!

    ,vemix
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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