#1   Report Post  
Old June 15th 11, 11:57 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 34
Default 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   Report Post  
Old June 15th 11, 01:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,853
Default 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   Report Post  
Old June 15th 11, 05:23 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 5,934
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add no. of days to a workday to get new workday? blswes Excel Worksheet Functions 1 April 15th 10 07:39 PM
Workday native earthling Excel Worksheet Functions 3 April 6th 09 03:45 AM
WORKDAY Daniel Q. Excel Worksheet Functions 6 August 13th 08 03:20 PM
WORKDAY() and probably more Epinn New Users to Excel 19 September 24th 06 01:19 PM
Workday Help mhart210 Excel Discussion (Misc queries) 3 July 10th 06 03:20 PM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017