Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 16th 13, 11:01 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2013
Posts: 10
Question Set date minuse 1 working day

Hello

Im struggling and cant locate a fix please help.

i have a date Exp: 20/01/13 in cella A2 and i want cell B2 to show me the previous working day. Coluld someone please help me?

Thanks in Advance.

Chris

P.s i am using excel 2003

  #2   Report Post  
Old July 17th 13, 12:15 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default Set date minuse 1 working day

On Tue, 16 Jul 2013 23:01:44 +0100, lostgrave2001 wrote:


Hello

Im struggling and cant locate a fix please help.

i have a date Exp: 20/01/13 in cella A2 and i want cell B2 to show me
the previous working day. Coluld someone please help me?

Thanks in Advance.

Chris

P.s i am using excel 2003


b2: =workday(a2,-1)

If you get a #NAME error, examine HELP for the WORKDAY function for instructions on adding the Analysis ToolPak
  #3   Report Post  
Old July 17th 13, 05:57 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 279
Default Set date minuse 1 working day

In message of Tue, 16 Jul
2013 19:15:34 in microsoft.public.excel.newusers, Ron Rosenfeld
writes
On Tue, 16 Jul 2013 23:01:44 +0100, lostgrave2001 <lostgrave2001.c2b835
wrote:


Hello

Im struggling and cant locate a fix please help.

i have a date Exp: 20/01/13 in cella A2 and i want cell B2 to show me
the previous working day. Coluld someone please help me?

Thanks in Advance.

Chris

P.s i am using excel 2003


b2: =workday(a2,-1)

If you get a #NAME error, examine HELP for the WORKDAY function for
instructions on adding the Analysis ToolPak


Ron,
Thanks for answering the question.
I looked at the WORKDAY worksheet function and see it includes an
optional holiday parameter.
If I had a need for workday, I would want to specify a list of holidays
in some fashion, which was shared among all worksheets in my
installation of Excel.
Tools/Options/Custom List allows new lists to be specified. Such lists
are shared. How can such a list be used in workday?
Alternatively, can you suggest another mechanism?
Just to put numbers on the problem, my holiday list contains December
25, December 26 and January 01.
Like Chris, I use Excel 2003.
--
Walter Briscoe
  #4   Report Post  
Old July 17th 13, 11:03 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default Set date minuse 1 working day

On Wed, 17 Jul 2013 05:57:42 +0100, Walter Briscoe wrote:


Ron,
Thanks for answering the question.
I looked at the WORKDAY worksheet function and see it includes an
optional holiday parameter.
If I had a need for workday, I would want to specify a list of holidays
in some fashion, which was shared among all worksheets in my
installation of Excel.
Tools/Options/Custom List allows new lists to be specified. Such lists
are shared. How can such a list be used in workday?
Alternatively, can you suggest another mechanism?
Just to put numbers on the problem, my holiday list contains December
25, December 26 and January 01.
Like Chris, I use Excel 2003.


On one of your worksheets, merely set up your list of holidays. Then refer to it either directly or, if you have NAME'd the list, by it's NAME.
You might put the list, for example, in Sheet3!A1:A3 and Define Name: Holidays Refers To: Sheet3!$A$1:$A$3
Then =WORKDAY(your_base_date, -1, Holidays)

A caveat: The dates must be full dates -- not just month and day.


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
working out days between date. phil Excel Worksheet Functions 6 April 25th 07 02:57 PM
Can Excel add working days to a date to result in another date? cwalrus Excel Worksheet Functions 1 May 16th 06 07:27 PM
Working out the date Spiller Excel Discussion (Misc queries) 5 March 29th 06 01:08 AM
date (minus) date = working days diff jjj Excel Discussion (Misc queries) 3 December 6th 05 03:16 PM
the date format is not working ,sort by date doesn't work. Rosa Campos Excel Discussion (Misc queries) 1 September 12th 05 10:52 PM


All times are GMT +1. The time now is 10:47 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017