If you read the title and had a flashback to the Geico commercial with the camel wandering around the office - I hope it put a smile on your face. If you have no idea what I am talking about - you might want to check it out here.
Ok, so I am not writing about camels or insurance. But I AM writing about "what day it is".
Have you ever had a spreadsheet with data that included dates and someone (maybe you) was wondering what day of the week each date corresponded to? As I am sure you know, in healthcare, day of the week matters. There may be different arrival patterns in the ED, there might be different staff scheduled in the birthing unit, There might be...I think you get the idea. Saturdays are not the same as Tuesdays.
Excel has a formula to extract the day of the week from a date field that assigns number values to the day of the week depending on which criteria you enter (Monday = 1, Tuesday = 2, and so on). This is helpful, except it leaves people asking, "what day is it?" - as in - "are the 1's Mondays or Sundays?"
I've got a simple way to bring the names of the days into your spreadsheet so that no one is left trying to decode your data. i.e. Monday = Monday, Tuesday = Tuesday...easy, right?
Check out this video and I'll show you exactly how to do it. :)
Thinking of Outsourcing your Internal Audits?
Christopher M. Spranger, MBA, ASQ MBB
Want to receive free tips to improve your business?