Dont count weekends

[sungen99]

Todays date is x ok. Its easy to get yesterdays date by doing x-1. But if I only want to have WORKDAYS and I do x-2 (which by the way is doing a look up function and because there is no data for weekends) I get a #N/A. How do I tell it to only use weekdays?

Thank you in advance,
Ken

[Paul Sheppard]

Todays date is x ok. Its easy to get yesterdays date by doing x-1. But if I only want to have WORKDAYS and I do x-2 (which by the way is doing a look up function and because there is no data for weekends) I get a #N/A. How do I tell it to only use weekdays?

Thank you in advance,
Ken

Hi Ken

Try this =WORKDAY(A1,-2), where todays date is in cell A1, this can also be adjusted to take account of holidays, look up WORKDAY function in help to find how, if required

[sungen99]

I seem to have a problem with that. I am using b1 as my date. and when i do
=workday(B1-1) i receive as #NAME? error.

I did some research on the function but still cant get it to work. I know it MUST be something very simple but I never claimed to be smart.

Ken

[Dave Peterson]

=workday() is part of the analysis toolpak addin.

Tools|addins|check Analysis ToolPak

If that option isn't available, you'll have to find your distribution disks and
run setup to install it.

Paul Sheppard wrote:
>
> sungen99 Wrote:
> > Todays date is x ok. Its easy to get yesterdays date by doing x-1. But
> > if I only want to have WORKDAYS and I do x-2 (which by the way is doing
> > a look up function and because there is no data for weekends) I get a
> > #N/A. How do I tell it to only use weekdays?
> >
> > Thank you in advance,
> > Ken
>
> Hi Ken
>
> Try this =WORKDAY(A1,-2), where todays date is in cell A1, this can
> also be adjusted to take account of holidays, look up WORKDAY function
> in help to find how, if required
>
> --
> Paul Sheppard
>
> ------------------------------------------------------------------------
> Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
> View this thread: http://www.excelforum.com/showthread...hreadid=483298

--

Dave Peterson

[sungen99]

WOOT! it works! thanks!!!