Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default Calculating new date by entering number of additional workdays

Would love some assistance with the following:

If I have a start date in a cell (A1), I am hoping to enter a number of
additional workdays into another cell (B1), resulting in a new date --
skipping weekends -- in a third cell (C1). Looking for the formula for C1.

If it helps, here's an example:
* Start date = 4/1/10 (which is a Thursday)
* Additional workdays = 5
* Solution = 4/7/10 (because it skipped the weekend)

Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 376
Default Calculating new date by entering number of additional workdays

Hi

Ensure that you have the Analysis Toolpak loaded.
ToolsAddinsAnalysis Toolpak

then with startdate in A1, number of days to add in B1
=Workday(A1,B1)

Optionally you can include holidays. With a list of holiday adtes in C1:C20
=Workday(A1,B1,$C1:$C20)
--
Regards
Roger Govier

blswes wrote:
Would love some assistance with the following:

If I have a start date in a cell (A1), I am hoping to enter a number of
additional workdays into another cell (B1), resulting in a new date --
skipping weekends -- in a third cell (C1). Looking for the formula for C1.

If it helps, here's an example:
* Start date = 4/1/10 (which is a Thursday)
* Additional workdays = 5
* Solution = 4/7/10 (because it skipped the weekend)

Thanks in advance.

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
Calculating number of workdays between 2 dates Gibbyky2 Excel Worksheet Functions 15 April 1st 11 12:31 PM
Adding Number of Workdays to a Date (Projects) GOMEZ Excel Discussion (Misc queries) 1 March 5th 07 04:59 AM
Calculating number of workdays PO Excel Worksheet Functions 1 August 31st 06 01:40 PM
How do I find total number workdays from a range of date faisalm Excel Worksheet Functions 3 July 4th 06 11:30 PM
Adding a number to a date as workdays Chris Maximus Excel Worksheet Functions 6 December 8th 04 08:48 PM


All times are GMT +1. The time now is 05:43 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"