A
amran.majid
From: (e-mail address removed)
Newsgroups: microsoft.public.excel
Subject: issue with Workday Function - not calculating workdays
correctly!
Date: Thu, 05 Oct 2006 12:23:03 -0000
hi,
trying to use the workday function to calculate the number of workdays
from a specific date.
i am trying to calculate the 11th working day for each month.
it works for October, but not november and december 2006.
A1 = 01/10/2006
B1 = 02/11/2006
C1 = 03/12/2006
A2 = WORKDAY(A1,11,Holidays) returns a value of 16/10/2006 which is
correct.
B2 = WORKDAY(A1,11,Holidays) returns a value of 16/11/2006 which is
incorrect. it should be 15/11/2006 (wed 01/11 - wed 15/11)
C2 = WORKDAY(A1,11,Holidays) returns an uncorrect value of 18/12, it
should be 15/12/2006.
curiously January 2007 is ok on 16/01/2007
whats going on?
Newsgroups: microsoft.public.excel
Subject: issue with Workday Function - not calculating workdays
correctly!
Date: Thu, 05 Oct 2006 12:23:03 -0000
hi,
trying to use the workday function to calculate the number of workdays
from a specific date.
i am trying to calculate the 11th working day for each month.
it works for October, but not november and december 2006.
A1 = 01/10/2006
B1 = 02/11/2006
C1 = 03/12/2006
A2 = WORKDAY(A1,11,Holidays) returns a value of 16/10/2006 which is
correct.
B2 = WORKDAY(A1,11,Holidays) returns a value of 16/11/2006 which is
incorrect. it should be 15/11/2006 (wed 01/11 - wed 15/11)
C2 = WORKDAY(A1,11,Holidays) returns an uncorrect value of 18/12, it
should be 15/12/2006.
curiously January 2007 is ok on 16/01/2007
whats going on?