close

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


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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=506299

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄