Forum Discussion
=COUNTIF($F7:$CQ7, "V")
See the attached version.
If you take up 6 hours of vacation on a day, enter v6.
If you take up 3 hours of personal time on a day, enter p3.
If the entire day is a sick day, enter s8.
This required only minimal changes instead of a major restructuring of the worksheets. I hope you can work with this.
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
See the attached version.
If you take up 6 hours of vacation on a day, enter v6.
If you take up 3 hours of personal time on a day, enter p3.
If the entire day is a sick day, enter s8.
This required only minimal changes instead of a major restructuring of the worksheets. I hope you can work with this.
- Thank you ever so much. I truly appreciate you.
- Just wanted to say I notice it says you are from the Netherlands. I am going to Scotland this year...