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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dannyboy213"
wrote in message
...

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


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile:
http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=507351