Businessday (Networkday) Function

[dannyboy213]

Is there an equivalent formula for the NETWORKDAY function without
having to install the add-in "Analysis ToolPak"?
I am trying to create a function where it tells me day the last
businessday.
Example: Let's say today is Monday and the date is 1/30/06 and I want
on the next cell to figure out that the last business date was 1/27/06.
The problem is, I don't want to use the "Analysis Toolpak".

 

[Bob Phillips]

=A1-1-(WEEKDAY(A1)=2)*2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dannyboy213" <[email protected]>
wrote in message
news:[email protected]...

 

[SteveG]

If you consider a business day any weekday from Monday - Friday
regardless of holidays, I am pretty sure the WEEKDAY function is a
standard function. I came up with,

=IF(WEEKDAY(A1,2)=1,A1-3,IF(WEEKDAY(A1,2)=7,A1-2,A1-1))

Your date is in A1. This looks to see if the date is a Monday and if
so, subtracts 3 days from it, if a sunday, subtracts 2 days all other
subtract 1 day.

Does that help?

Steve

 

[dannyboy213]

It works! Thank you very Much Bob

 

[Bob Phillips]

It's a pleasure.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dannyboy213" <[email protected]>
wrote in message
news:[email protected]...