Sign up for my email newsletter and get free access to my analytics resource library.

Stringfest Analytics

Teaching analytics with modern Excel

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

posted on

 

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.

Newsletter signup

Please wait...

Thank you for signing up. I look forward to becoming savvier about data with you.

Reader Interactions

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.