Excel for Healthcare Tip: Calculating On-Call Points with WEEKDAY( )


The WEEKDAY( ) function will return a number representing the day of the week for any date.

In this example, I will show you how to use this to transform an on-call calendar from a slow, manual process to a quick table that is ready for PivotTable analysis.

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: