=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