ExcelBanter - Days from a date excluding weekends and holidays

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Days from a date excluding weekends and holidays (https://www.excelbanter.com/excel-discussion-misc-queries/450656-days-date-excluding-weekends-holidays.html)

WarrantyAdmin

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.

Claus Busch

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

All times are GMT +1. The time now is 03:43 AM.