Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 120
Default Formula Subtracting Business Days

I need to create a formula that will take a date that I have listed in my
spreadsheet and subtract from it the number of business days.

For example

Date in cell A1 11/12/2007
Number of Business days to subtract in A2 12
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,202
Default Formula Subtracting Business Days

I need to create a formula that will take a date that I have listed in my
spreadsheet and subtract from it the number of business days.

For example

Date in cell A1 11/12/2007
Number of Business days to subtract in A2 12


=WORKDAY(A1,-A2)

Note that this function requires the Analysis ToolPak be enabled (found at
Tools/Add-Ins on Excel's menu bar. The WORKDAY function also allows you to
account for holidays if you want (see the help files).

Rick

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Formula Subtracting Business Days

In Call A1:
11/12/2007

In Cell A2:
11/1/2007

In Cell A3:
=NETWORKDAYS(A2,A1)

Result:
8

From Help:
NETWORKDAYS(start_date,end_date,holidays)


Regards,
Ryan---


--
RyGuy


"Erika" wrote:

I need to create a formula that will take a date that I have listed in my
spreadsheet and subtract from it the number of business days.

For example

Date in cell A1 11/12/2007
Number of Business days to subtract in A2 12

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 120
Default Formula Subtracting Business Days

How do I get the formula to give me the result of 11/1/2007 if I have

In cell A1:
11/12/2007

In cell A2:
8

Formula result 11/1/2007

"ryguy7272" wrote:

In Call A1:
11/12/2007

In Cell A2:
11/1/2007

In Cell A3:
=NETWORKDAYS(A2,A1)

Result:
8

From Help:
NETWORKDAYS(start_date,end_date,holidays)


Regards,
Ryan---


--
RyGuy


"Erika" wrote:

I need to create a formula that will take a date that I have listed in my
spreadsheet and subtract from it the number of business days.

For example

Date in cell A1 11/12/2007
Number of Business days to subtract in A2 12

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
Excel formula where I can add business days (date) kskaug1 Excel Discussion (Misc queries) 3 September 1st 06 07:59 PM
Business Days in Chart Terence Charts and Charting in Excel 1 August 10th 06 03:37 PM
Business Days Only lsmft Excel Discussion (Misc queries) 11 March 10th 06 01:16 PM
Date Formula Needed-Business Days MauiTim Excel Discussion (Misc queries) 2 November 25th 05 09:31 PM
Formula to make Excel count business days/skip weekends? Inga Excel Worksheet Functions 1 November 17th 04 08:45 PM


All times are GMT +1. The time now is 05:30 PM.

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

About Us

"It's about Microsoft Excel"