PC Review


Reply
Thread Tools Rate Thread

How do I calculate future dates excluding weekends and holidays?

 
 
=?Utf-8?B?dGVycmlrYWxlZQ==?=
Guest
Posts: n/a
 
      7th Sep 2006
Is there an expression or function which would allow me to calculate future
dates (based on the current date) but exclude weekends and holidays (business
days)?
 
Reply With Quote
 
 
 
 
Rick B
Guest
Posts: n/a
 
      7th Sep 2006
Do a search and read the previous posts on the topic. This is asked and answered very often. Look for "business days" or "work days".

The following is from a previous post:

Business Days
Arvin Meyer has some code on his site you might find useful: http://www.datastrat.com/ and go to Downloads>CodeDownloads : GetBusinessDay.

A very straightforward function where you supply today's date and how many Bdays in the future/past you want returned. It requires a "Holidays" table.


--
Rick B



"terrikalee" <(E-Mail Removed)> wrote in message news:46F79671-F8D0-42AF-A36C-(E-Mail Removed)...
> Is there an expression or function which would allow me to calculate future
> dates (based on the current date) but exclude weekends and holidays (business
> days)?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate End Date (excluding weekends and holidays) guitaronmyback Microsoft Excel Worksheet Functions 6 6th May 2009 10:17 PM
Calculate a future date excluding weekends and holidays MJS 2007 Microsoft Access Forms 4 16th Oct 2008 02:18 AM
Calculate A Date Excluding Weekends And Holidays travelersway Microsoft Excel New Users 9 9th Feb 2006 01:36 AM
Re: Calculate A Date Excluding Weekends And Holidays travelersway Microsoft Excel New Users 1 8th Feb 2006 08:56 PM
Calculating dates excluding weekends/holidays? Mark Microsoft Access Queries 7 27th Jul 2004 12:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:14 AM.