Category Archives: VBA

Microsoft Excel – Number of Working Days in a month

Microsoft Excel 2010 - LogoI 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).

Continue reading Microsoft Excel – Number of Working Days in a month

Getting Day Names and Month Names in Microsoft Excel using VBA

 

Microsoft Excel 2010 - LogoMy 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.

 

Continue reading Getting Day Names and Month Names in Microsoft Excel using VBA