Working Days

[Guest]

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

 

[daddylonglegs]

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 da
based on today's date

=WORKDAY(TODAY(),-1)

you also have an option to include holidays...