# Excel Function – Weekdays in Month – Excel Challenges

Hope you are having a great day! MVP Jordan Goldmeier is back with Excel challenge to test your knowledge on Excel functions. Let us look at the previous week’s Excel challenge before getting in to this week’s challenge.

## Last Week’s Challenge

Last week’s challenge was “What is the difference between objects using early-binding and objects using late-binding?” Have you answered this?

## Correct Answer For Last Week’s Challenge

Jordan said that we did not have a lot of people sending the responses. So, answer for this challenge would be discussed in the coming episodes as this is the important Excel challenge. This is not going to extend further and we have new challenge for this episode. But, you can keep sending answers for this challenge.

What is the function to determine number of weekdays in calendar month?

This week’s challenge is to test your knowledge in Excel functions. “Which of the following functions can be used in a simple formula to determine how many weekdays there are in any calendar month?” Jordan has provided you the options as well and here they are,

a. EOMONTH

b. NETWORKDAYS

c. DAYS360

d. WEEKDAY

So, send us the correct option as A, B, C or D. You can even specify the function name directly.

Tags

#### You may also like

December 20, 2013

## 100+ Best Excel Resources And Websites

100+ Best Excel Resources And Websites

August 6, 2019

## How to Create a Relative File Path in Power Query

How to Create a Relative File Path in Power Query

December 20, 2013

## 100+ Best Excel Books – Learning Spreadsheets

100+ Best Excel Books – Learning Spreadsheets

April 9, 2011

## How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

September 17, 2012

## The Excel Rollover Mini FAQ

The Excel Rollover Mini FAQ

February 17, 2014

## It’s time to say “Goodbye,” to Hungarian Notation

It’s time to say “Goodbye,” to Hungarian Notation