Dont count weekends

S

sungen99

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

Thank you in advance,
Ke
 
P

Paul Sheppard

sungen99 said:
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
Click to expand...

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
 
S

sungen99

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

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

Ke
 
D

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.
 
Top