October 14

Excel Function – Weekdays in Month – Excel Challenges

0  comments

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.

Hurry Up To Answer

Go ahead and comment your answer in Excel TV blog post or Excel TV Challenges forum at VBAExpress.com or Facebook (facebook.com/ExcelTVSeries) or comment on the video. You can even tweet to @ExcelTV or mail at Challenge@ExcelTVShow.com. Come On!

 


Tags


You may also like

51: Oz du Soleil & the Global Excel Summit 2021

51: Oz du Soleil & the Global Excel Summit 2021

Global Excel Summit 2021

Global Excel Summit 2021
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

>