Using WORKDAY function which is part of Analysis ToolPak addin

=WORKDAY(A1,-1)

where your date is in A1

If you want the formula to automatically show previous working day
based on today's date

=WORKDAY(TODAY(),-1)

you also have an option to include holidays....


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506299