Tag Archives: Dates

Microsoft Excel – Weekday Function and VLookups

Microsoft Excel 2010 - LogoMicrosoft Excel is the world’s most used spreadsheet tool.  But what do people use it for really?  I would admit that I began using it at school for creating lists and slight calculations.  However, now with what I have learnt in terms of automation, KPI creation, VBA and analysis. Continue reading Microsoft Excel – Weekday Function and VLookups

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