Want to know how many days you have to work in this month??

image_pdf

It always makes happy to know that there are many holidays and few working days in this month? Isn't it?? Let's check out how Excel can help us in that.

We will be learning three functions in this article. WEEKDAY(), WORKDAY() and NETWORKDAYS(). This functions are also useful to get the day of the week from date and how to get weekdays/workingdays between two workind days.

1. How to use WEEKDAY function?

The WEEKDAY function is used to get the day of the week in form of number between 1(Sunday) to 7(Saturday) from the given date.

Example:

weeday

Read more: Calculate the difference between two dates using DATEDIF Function

2. How to use WORKDAY function?

The WORKDAY function is used to get date based on supplied number of days from the start date excluding weekends and holidays. Weekends includes Saturday and Sunday both.

Syntax:

=WORKDAY( start_date, days, [holidays] )

start_date: The initial date from which we count the number of workdays.

days: The number of work days to be added to the start date.

[holidays]: Optional argument which specifies the array of dates which are to be excluded.

Example:

workday workday1

Learn More: Play with Date!! change look or divide in parts or add some more days..!!

3. How to use NETWORKDAYS function?

The NETWORKDYS function calculates the number of working days between the two given dates excluding the holidays.

Syntax:

= NETWORKDAYS( start_date, end_date, [holidays] )

start_date: The initial date.

end_date: The end date.

[holidays]: Optional argument which specifies the array of dates which are to be excluded.

Example:

networkday networkday1

Explore more, It's Amazing…

3 most useful Lookup function to easily fetch data

How to customize Date and Time format in Excel?

For any kind of queries on MS Excel, please feel free to Contact us.

Stay tuned with us on www.facebook.com/amazingxcel for more amazing tips on MS Excel.

 

12,200 total views, 9 views today

3 thoughts on “Want to know how many days you have to work in this month??

  1. Hi,

    Ankita,

    We appreciate your work. and Thanks for your best support in excel.

    I have leant many thing from Amazing Excel.

    I have seen your todays article "How to convert data from text to columns in excel" and i have one query.

    After converting data in separate Columns how do we together that contain in one cell…?

    Thanks & Regards,

    Nilesh

     

  2. I wants to add 5 days in date format "3/17/2016  2:33:00 AM" with time constant. What formula should I use? By using WORKDAY(3/17/2016  2:33:00 AM,5) getting output as " 3/24/16 12:00 AM" instead of 3/24/16 2:33:00 AM" 

    Please help.

     

     

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>