New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

I use networkdays.intl function two times in a cell with different date ranges but output is wrong

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

I use networkdays.intl function two times in a cell with different date ranges but output is wrong

Postby vikas270880 » Sat May 28, 2016 1:29 am

Hi,

I want to calculate leaves taken by the employees. the only problem i face is when an employee apply for a half day leave, cause excel cannot determine a half day so I have to do it manually. I wanted the automatic calculation so I tried something:

I tried follow formula wherein E1 & F1 are made for half day leaves and G1 & H1 for full day leave. "11" is the holiday code and "$M$4:$M$11"is the list of holidays.

I divided the first formula with 2 to get half days as the result. The G1 & H1 cells are kept blank.

The output should have been 0.50 but it is calculating the blank cells (G1 & H1) as 1 and the output that I am getting is 1.50

=NETWORKDAYS.INTL(E1,F1,11,$M$4:$M$11)/2+NETWORKDAYS.INTL(G1,H1,11,$M$4:$M$11)

I am not so very technical so my apology for my choice of words. I hope my problem can be understood. is there any solution for this?
  • 0

vikas270880
Rookie
 
Posts: 5
Joined: May 28, 2016
Reputation: 0
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 39 guests