Ask Experts Questions for FREE Help !
Ask
    mitank's Avatar
    mitank Posts: 8, Reputation: 1
    New Member
    		  
    #1

    Dec 17, 2008, 10:30 PM
    Calculate Holidays in Excel
    I want to calculate Holidays for an employee

    For Eg. Holiday company has given is on 10.12.2008.

    Now if the employee comes to work on 9.12.2008 and 11.12.2008 he is marked present on 10.12.2008 and is given 1 holiday (not 3 as 9.12.2008 and 11.12.2008 are working days)

    If the employee comes either on 9.12.2008 and remains absent on 11.12.2008 OR he remains absent on 9.12.2008 and comes on 11.12.2008 he is again marked present on 10.12.2008 and is given 1 holiday. (not 2 as he has worked either on 9.12.2008 or 11.12.2008 as being working days)

    BUT if the employee does not come on 9.12.2008 OR 11.12.2008 he is marked ABSENT on 10.12.2008 and is not given the holiday benefit.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Dec 18, 2008, 12:00 AM

    You provide logic, but no context to give you an answer. So, if you just want to see how some COUNTIF() and IF(AND() formulas can accomplish what you've described, I've attached a book to give you an inkling.
    Attached Files
  1. File Type: xls Holiday.xls (13.5 KB, 497 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Holidays [ 3 Answers ]

Hopefully everyone had a great Thanksgiving. The Holidays are here again-so soon! This time of year is not a time of joy for everyone. In fact, it can be a very depressing time for a lot of us. I wanted to open this thread in hopes people will come to talk if they are starting to feel depressed...

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Holidays in the UK [ 2 Answers ]

Hi, Last year my dad had a very serious stroke and is now very disabled, and also diabetic. He is currently in a residential care home while my mum sells their house and we manage to buy a house suitable for him to reutrn to. We want to go on holiday, but obviously don't want to have to leave my...

Yes - happy holidays all [ 10 Answers ]

I'll be traveling the next 10 days or so. I'll have my laptop and go to cyber cafes. I doubt I will make it to this site much. Anyone can feel free to send me a private e-mail throug hthe site and I will get back to them. Take care all - enjoy your holidays. Be safe on New Years!!

View more questions Search