I came across a question on LinkedIn from someone who wanted to know how to count the number of working days in a month. Now I know that there is a WORKDAY function within Excel which is supposed to take into account holidays but, this doesn’t take into account different national holidays in different time-zones (to the best of my knowledge).
My last post I blogged about how to get the Day Names and Month Names using VLOOKUPs. However, today let’s look at doing exactly the same but, using VBA (Visual Basic for Applications). Now for the non-coders reading this it may seem kinda scary but, give it a go and you may be surprised about how easy coding in Excel can be.
I would recommend though that you learn in a practice document that isn’t going to affect real data or an existing document.