When 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.