• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count hours (9hrs per day Mon-Thursday) 4 hours every Friday between dates


New Member
I want to count working hours only between two different dates but I have weird condition as I want to count "9 hours" as per day between Monday to Thursday and 4hours every Friday.
Saturday and Sunday are non working days + calendar holidays. I'm super stressed and I did not find solution even I watch all youtube and google so much.. can someone rescue me please? attached excel sheet. Thanks in advance. God Bless you!!


  • Annual Leave Tracker 2024.xlsx
    19.8 KB · Views: 4
Thanks Belleke. If there will be no Friday will it will still do -5. I don't know if it works! I want a conditional formula that applies as count everyday 9hours (Mon - Thursday) and count 4 hours every Friday - Days should be detected automatically. for example if there is 2 Fridays then 4 hours each Friday should be automatically counted.


  • Annual Leave Tracker 2024.xlsx
    19.8 KB · Views: 3
Last edited:
Guys you are the besssssssssssssssssssssssssssst!! You have make my day and life easy!! Stay always best.... EXPERTS!!!