Using WORKDAY function

[MT]

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 are: 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 are: 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 Coderre]

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 are: 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 are: 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.
>
>

[MT]

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 are: 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 are: 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.
> >
> >