| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Working time and days | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
Linear Mode
