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. :)