Microsoft Excel Question:
Download Job Interview Questions and Answers PDF
I am using Microsoft Excel and I would like to know if there is an easy way to figure out the number of working days (Monday through Friday) between two dates and also exclude specific holidays?
Answer:
Yes, you can use the NETWORKDAYS function. The following is the syntax for the function: NETWORKDAYS(START_DATE,END_DATE,HOLIDAYS) START_DATE is a date that represents the start date. END_DATE is a date that represents the end date. HOLIDAYS is an optional range of one or more dates to exclude from the working calendar.
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How can I vary the width in the columns of a spreadsheet? | Is there a way to set up a toolbar button in Excel to access Page Setup? |