Getting Day Names and Month Names in Microsoft Excel using VLOOKUPS

Microsoft Excel 2010 LogoWhen creating Dashboards, insight reports and spreadsheets it is something important to give day names or month names rather than a specific date string.  Now this isn’t as hard as it looks but, all that Excel provides you with is a day number or month number.  So why not translate that into something more meaningful?

This post will show you how to change day numbers and month numbers into names in two methods.  The first by using VLOOKUPS (don’t worry they aren’t are terrifying as that) and secondly in VBA (visual basic for applications) which will be published in a second blog post.

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