Healthcare Business Management Association - HBMA
Leading the Business of Healthcare Login
Calculating Weekdays in Excel
By Nate Moore, CPA, MBA, CMPE

Medical billing companies store a wide variety of data that can really help the practices they support. In this article, we will look at how dates of service or other dates in a billing system can be converted to weekdays so that medical practices can analyze things like weekend call premiums or productivity by day of the week. Here are two ways to show whether or not a given date is a weekday or a weekend.

Not a Member?

Click here to purchase an annual subscription to our Billing Journal! Click here to purchase an annual
subscription to our Billing Journal!
 
Tell me more! Learn about our member benefits... Tell me more! Learn about
our member benefits...
 
Join Now! Gain immediate access to all online membership benefits. Join Now! Gain immediate access
to all online membership benefits.
Non Members can download one copy of Billing - click here to download yours today! Non Members can download one copy of Billing.
Click here to download yours today!
 
Email the membership department. Email the membership department.

Welcome, Please Sign In
Username:
Password:
Remember Login:

 Return to Issue Index