Workdays in Excel tutorial

This is a quick tutorial on worday function in Microsoft Excel. Workday function returns a date for a working day before or after a given date. It excludes weekends and any dates identified as holidays.



Syntax

=WORKDAY(Starting date;number of working days; (holidays) optional list of dates to exclude)

Note: depending on your regional settings, you might have to use comma (,) as a separator instead of semicolon (;)

Example

Get the date for working day after 8 days, starting date in cell A1:

=WORKDAY(A1;8)

Get the date for working day after 31 days, excluding holidays defined in cells B1:B4. Starting date in cell A1:

=WORKDAY(A1;31;B1:B4)

That's it for now, enjoy.

17 comments:

  1. Nice article, thanks for sharing the information. We also provide Workday online training check this site Tekslate for indepth Workday training.

    ReplyDelete
    Replies
    1. I am technology Enthusiast. Your blog is really awesome, attractive and impressive. I like the way you think. it is very useful for Java SE & Java EE Learners. Your article adds best knowledge to our Java Online Training India. or learn thru Java Online Training India Students. or learn thru JavaScript Online Training India. Appreciating the persistence you put into your blog and detailed information you provide. Kindly keep blogging.

      Delete
  2. good tutorial we have to provide that the workdays functionally and excel conceots.thank you so much
    Tableau Training Tableau Online Training

    ReplyDelete
  3. Cool post, thanks. Speaking about online technologies. I suggest to keep your paperwork stored online. Read about idealsvdr data rooms and everything will be clear.

    ReplyDelete
  4. Nice Posting done by you. i always find you your blog interesting.keep on posting such nice things..microsoft courses malaysia

    ReplyDelete
  5. wow...nice blog, very help full information. Thanks for sharing.

    Best Software company in New jersey, USA

    ReplyDelete

  6. Digital Transformation |Austere Technologies
    Very good informative article. Thanks for sharing such nice article, keep on up dating such good articles.

    ReplyDelete
  7. VERY INFORMATIVE BLOG. KEEP SHARING SUCH A GOOD ARTICLES.

    Best Cloud Solutions | Austere Technologies

    ReplyDelete
  8. Really great blog, it's very helpful and has great knowledgeable information. Thanks for sharing, keep updating such a good informative blog.

    Best IT Security Services | Austere Technologies

    ReplyDelete
  9. REALLY VERY EXCELLENT INFORMATION. I AM VERY GLAD TO SEE YOUR BLOG FOR THIS INFORMATION. THANKS FOR SHARING. KEEP UPDATING.
    Austere Technologies|Mobility

    ReplyDelete
  10. Excellent information you made in this blog, very helpful information. Thanks for sharing.

    Best Commerce College| Avinash college of commerce

    ReplyDelete
  11. Great article, really very helpful content you made. Thank you, keep sharing.

    Best junior college in Hyderabad | Avinash College of commerce

    ReplyDelete
  12. AWS Training in Bangalore - Live Online & Classroom
    myTectra Amazon Web Services (AWS) certification training helps you to gain real time hands on experience on AWS. myTectra offers AWS training in Bangalore using classroom and AWS Online Training globally. AWS Training at myTectra delivered by the experienced professional who has atleast 4 years of relavent AWS experince and overall 8-15 years of IT experience. myTectra Offers AWS Training since 2013 and retained the positions of Top AWS Training Company in Bangalore and India.


    IOT Training in Bangalore - Live Online & Classroom
    IOT Training course observes iot as the platform for networking of different devices on the internet and their inter related communication. Reading data through the sensors and processing it with applications sitting in the cloud and thereafter passing the processed data to generate different kind of output is the motive of the complete curricula. Students are made to understand the type of input devices and communications among the devices in a wireless media.

    ReplyDelete