+ Reply to Thread
Results 1 to 12 of 12

Formula to count "absence with permission"

  1. 10-18-2018, 09:58 AM #1
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Formula to count "absence with permission"

    Hello everybody,
    Can you help me to solve my problem,please?
    -The file in attachment contains dates of leaves for employees
    -Dates are written in "00" format
    -"Absence with permission" is allowed only if emplpyee`s annual balance is zero
    My question:I need a formula to count "absence with permission" if the employees`s annual balance "until current month" is more than zero.Because it is a mistake if the employee took absence before finishing his annual balance.

    Note:I mentioned "annual balance until current month" not "the final annual balance"
    please help me
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-18-2018, 11:14 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Formula to count "absence with permission"

    Am I reading this correctly?? Do you want a formula to return the values in E15, K15, etc?

    Edit: forget it. I haen't a clue what you want, as (amongst other things) I have no idea where you get the "annual balance to current month" from.
    Last edited by Glenn Kennedy; 10-18-2018 at 11:25 AM.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 10-19-2018, 05:01 AM #3
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769
    The formula I ask for should calculate "annual balance to current month ".
    Note:there should be a formula for every column"absence with permission"
    Please help me
    Last edited by AliGW; 10-19-2018 at 05:07 AM. Reason: Please do not quote unnecessarily.
    Reply With QuoteRegister To Reply
  4. 10-19-2018, 05:08 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,728

    Re: Formula to count "absence with permission"

    Just repeating what you have already said is not going to help us to help you.

    Please answer Glenn's questions:

    1. Do you want a formula to return the values in E15, K15, etc.?
    2. Where do you get the "annual balance to current month" from?

    You do not need to keep saying "please help me" - this is a help forum! Concentrate instead on answering questions and giving useful information.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 10-19-2018, 05:52 AM #5
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Formula to count "absence with permission"

    1-yes, But there should be a formula for every column E, k,... etc
    2-The formula -I asked for- should calculate "annual balance to current month ".
    Reply With QuoteRegister To Reply
  6. 10-19-2018, 05:53 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,728

    Re: Formula to count "absence with permission"

    2-The formula -I asked for- should calculate "annual balance to current month ".
    How would you calculate it manually? Where should the figure come from?

    You are not answering the question, but again simply repeating what you have already said.
    Reply With QuoteRegister To Reply
  7. 10-19-2018, 05:57 AM #7
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Formula to count "absence with permission"

    Manually,I depend on final balance every month. And this may lead to some mistakes.
    Reply With QuoteRegister To Reply
  8. 10-19-2018, 06:01 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,728

    Re: Formula to count "absence with permission"

    OK - I am sorry, but I have to leave it here. I would love to help you, but you are simply not giving me the information I am asking for.

    We are not here to work out the mathematics for you: that's up to you. What we can help you with is translating the mathematical calculation into a formula.

    If you want any further help from me, then tell me the exact manual calculation you would make to arrive at the value. If you can't do that, then I can't help you. Sorry.
    Reply With QuoteRegister To Reply
  9. 10-19-2018, 06:57 AM #9
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Formula to count "absence with permission"

    I use this formula ,in af15:
    Please Login or Register  to view this content.
    see z15,ac15,af15
    This formula works only on current month.If I entered data in a new month,it gets wrong result.
    see the attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 10-19-2018, 07:01 AM #10
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,728

    Re: Formula to count "absence with permission"

    Now we are getting somewhere! Thank you for this. I shall have a look shortly.
    Reply With QuoteRegister To Reply
  11. 10-19-2018, 08:19 AM #11
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula to count "absence with permission"

    E15
    Please Login or Register  to view this content.
    Try above array fromula and copy & Paste across
    Hope some one comes with better and simple formula

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  12. 10-20-2018, 09:08 AM #12
    leprince2007
    leprince2007 is offline
    Forum Contributor
    Join Date
    02-24-2015
    Location
    Egypt
    MS-Off Ver
    Office 365 ProPlus
    Posts
    769

    Re: Formula to count "absence with permission"

    thank you very much
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to count the number of "Marry" with last name "Sims" regardless of M.I.
    By spsssw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2017, 02:17 AM
  2. Need to count the numnber of "agree", "disagree" and "N/A" in a filtered list
    By mbeginner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2015, 01:13 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. [SOLVED] Cell Formula to count time with "Greater Than or Equal to" and "Less Than"
    By chriswhite1982 in forum Excel General
    Replies: 3
    Last Post: 06-16-2013, 12:30 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1