I'm trying to create an excel sheet to add a certain number of days to the current date and return that value. The problem is however that I want it to only count business days (excluding weekends and public holidays).
To start, I created 4 columns.
Column A contains all the days in the...
Hi guys
I hate to bother you with something so trivial, but I'm not having any luck by myself. :o Basically, I'm compiling stats for my team and hit a brick wall. What I need is some kind of formula that checks Column A, finds the word Fruit, then checks Column B and counts how many times the...