Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Days from a date excluding weekends and holidays

I understand how to use the NETWORKDAYS function, however, I am not trying to calculate number of work days between two dates. I want to know how many business days from a date. For example: I want to know what date is 35 business days from 9/1/2014. I have been trying different methods and have hit a wall. Please help.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Days from a date excluding weekends and holidays

Hi,

Am Fri, 13 Feb 2015 01:12:38 +0000 schrieb WarrantyAdmin:

I understand how to use the NETWORKDAYS function, however, I am not
trying to calculate number of work days between two dates. I want to
know how many business days from a date. For example: I want to know
what date is 35 business days from 9/1/2014. I have been trying
different methods and have hit a wall. Please help.


try it with WORKDAY


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
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
Formula for adding days to a date excluding weekends and holidays? Jake via OfficeKB.com Excel Discussion (Misc queries) 3 May 20th 23 07:48 PM
Calculate End Date (excluding weekends and holidays) guitaronmyback Excel Worksheet Functions 6 May 6th 09 10:17 PM
excel total days formula including weekends, excluding holidays wtfisch Excel Discussion (Misc queries) 0 May 7th 08 04:53 PM
Calculate A Date Excluding Weekends And Holidays travelersway New Users to Excel 1 February 8th 06 08:56 PM
How do you count work days excluding weekends and holidays? Hausma Excel Discussion (Misc queries) 2 April 8th 05 07:39 PM


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