Calculating Calendar Dates

V

V-Man

I have a spreadsheet where users input the initial due date for a service. Based on this initial date, I want to calculate 4 additional dates. Each of the subsequent dates are at a fixed intervals of 1 to 2 days. However, these dates cannot include weekends or holidays (only business days). Anyone know a spreadsheet function that would help me to calcuate these dates?

Thanks!
 
P

Peter Atherton

V-Man

Have a look at NETWORKDAYS function - it excludes weekends
and holidays providing that you have a list of bank-
holidays and factory closures in a range to include in
your formula.

Regards
Peter

[email protected]
-----Original Message-----
I have a spreadsheet where users input the initial due
Click to expand...
date for a service. Based on this initial date, I want to
calculate 4 additional dates. Each of the subsequent
dates are at a fixed intervals of 1 to 2 days. However,
these dates cannot include weekends or holidays (only
business days). Anyone know a spreadsheet function that
would help me to calcuate these dates?
 
F

Frank Kabel

Hi
use WORKDAY for this

--
Regards
Frank Kabel
Frankfurt, Germany

V-Man said:
I have a spreadsheet where users input the initial due date for a
Click to expand...
service. Based on this initial date, I want to calculate 4 additional
dates. Each of the subsequent dates are at a fixed intervals of 1 to 2
days. However, these dates cannot include weekends or holidays (only
business days). Anyone know a spreadsheet function that would help me
to calcuate these dates?
 
J

JE McGimpsey

Check out NETWORKDAYS(). It's an Analysis Toolpak Add-in function
(Tools/Add-ins...)
 
Top