Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last workday
How could i create a function that would aways show me last workday
before today? so for example: 1.today is wednesday 15 jun. So the function would show: tuesday 14 jun 2. today is monday 13 jun and the funtion would show: friday 10 jun tnx for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last workday
Hello,
Am Wed, 15 Jun 2011 03:57:05 -0700 (PDT) schrieb Mortir: 1.today is wednesday 15 jun. So the function would show: tuesday 14 jun 2. today is monday 13 jun and the funtion would show: friday 10 jun your date in A1. Then try: =A1-CHOOSE(WEEKDAY(A1),2,3,1,1,1,1,1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last workday
How could i create a function that would aways show me last
workday before today? so for example: 1.today is wednesday 15 jun. So the function would show: tuesday 14 jun 2. today is monday 13 jun and the funtion would show: friday 10 jun Try this formula... =WORKDAY(A1,-1) If you are using XL2003 or earlier, then you need to have the Analysis ToolPak add-in selected (Tools/Add-Ins on the menu bar). Rick Rothstein (MVP - Excel) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add no. of days to a workday to get new workday? | Excel Worksheet Functions | |||
Workday | Excel Worksheet Functions | |||
WORKDAY | Excel Worksheet Functions | |||
WORKDAY() and probably more | New Users to Excel | |||
Workday Help | Excel Discussion (Misc queries) |