Working Days
 

Hi..

How do i get excel to regonise the last working day..?

My Example.. On Monday show the previous Fridays date and on Tuesday display
the Mondays date..?

Thanks guys..

Working Days
 

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