Calculating Calendar Dates

[Guest]

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!

 

[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

(e-mail address removed)

-----Original Message-----
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?

 

[Frank Kabel]

Hi
use WORKDAY for this

--
Regards
Frank Kabel
Frankfurt, Germany

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?

 

[JE McGimpsey]

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

 

[JE McGimpsey]

Misread the post - check out WORKDAY() instead.