Hello, I'm trying to successfully use the WORKDAY function. I have created a
list of holidays, but what's happening is that I am unable to get both the
correct date and the time. If I get the correct date, the time is always
00:00:00 (and it should be adjusted accordingly), or, I will get the correct
time and the date is extremely far into the future. Can you please advise?
Thanks.

Here is an example:
The function: =WORKDAY(D5,2,Holiday!A1:A12)...results placed in E5
the above calculates from D5 -- Friday, 06/02/06 15:00:00
The results in E5 a 06/06/06 00:00:00
The above is great except for the time.

Then, when I tried:
The function this way: =D5+WORKDAY(D5,2,Holiday!A1:A12)
Let's use the same D5 -- Friday, 06/02/06 15:00:00
The results a 11/07/12 15:00:00
The above results give the correct time, but the date is way off!!!

I have not idea how to remedy this. Any ideas? I have checked my format
for the cells in question. The oddest thing, when I used the weekday
function in combination with the IF statement...all is well. I just need to
factor in the holidays and I was told that WORKDAY would be easier.

Thanks again.

Try this formula:

=WORKDAY(D5,2,Holiday!A1:A12)+MOD(D5,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MT" wrote:

Hello, I'm trying to successfully use the WORKDAY function. I have created a
list of holidays, but what's happening is that I am unable to get both the
correct date and the time. If I get the correct date, the time is always
00:00:00 (and it should be adjusted accordingly), or, I will get the correct
time and the date is extremely far into the future. Can you please advise?
Thanks.

Here is an example:
The function: =WORKDAY(D5,2,Holiday!A1:A12)...results placed in E5
the above calculates from D5 -- Friday, 06/02/06 15:00:00
The results in E5 a 06/06/06 00:00:00
The above is great except for the time.

Then, when I tried:
The function this way: =D5+WORKDAY(D5,2,Holiday!A1:A12)
Let's use the same D5 -- Friday, 06/02/06 15:00:00
The results a 11/07/12 15:00:00
The above results give the correct time, but the date is way off!!!

I have not idea how to remedy this. Any ideas? I have checked my format
for the cells in question. The oddest thing, when I used the weekday
function in combination with the IF statement...all is well. I just need to
factor in the holidays and I was told that WORKDAY would be easier.

Thanks again.

Ron,

Yes!!! This worked out!! Thanks again!!!

MT

"Ron Coderre" wrote:

Try this formula:

=WORKDAY(D5,2,Holiday!A1:A12)+MOD(D5,1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MT" wrote:

Hello, I'm trying to successfully use the WORKDAY function. I have created a
list of holidays, but what's happening is that I am unable to get both the
correct date and the time. If I get the correct date, the time is always
00:00:00 (and it should be adjusted accordingly), or, I will get the correct
time and the date is extremely far into the future. Can you please advise?
Thanks.

Here is an example:
The function: =WORKDAY(D5,2,Holiday!A1:A12)...results placed in E5
the above calculates from D5 -- Friday, 06/02/06 15:00:00
The results in E5 a 06/06/06 00:00:00
The above is great except for the time.

Then, when I tried:
The function this way: =D5+WORKDAY(D5,2,Holiday!A1:A12)
Let's use the same D5 -- Friday, 06/02/06 15:00:00
The results a 11/07/12 15:00:00
The above results give the correct time, but the date is way off!!!

I have not idea how to remedy this. Any ideas? I have checked my format
for the cells in question. The oddest thing, when I used the weekday
function in combination with the IF statement...all is well. I just need to
factor in the holidays and I was told that WORKDAY would be easier.

Thanks again.