Formula not skipping non-working time

[Greg]

I have marked company holidays as non-working time on the calendar using
Change Working Time. When I use a fomula in Date1, Date2, etc., it does not
incorporate those non-working time changes. For example, I have Date1 as
starting five days later than Start Date. However, it counts weekends and
holidays as part of the five days.

How do I calculate a date in Date1, Date2, etc that excludes non-working days?

 

[Gérard Ducouret]

Greg,

You want to calculate the duration between Date1 and Date2, in working days?
Use the ProjDateDiff function:
ProjDateDiff (date1,date2, "calendar")
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

 

[Greg]

No, actually I want to show several dates on one task. The start date, Date1
(which typically occurs 5 business days later), Date 2 (which occurs 3
business days after Date1), etc. What formula would I use to calculate the
new date which does not count holidays or weekends as part of the "5 business
days later"?

Greg,

You want to calculate the duration between Date1 and Date2, in working days?
Use the ProjDateDiff function:
ProjDateDiff (date1,date2, "calendar")
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

I have marked company holidays as non-working time on the calendar using
Change Working Time. When I use a fomula in Date1, Date2, etc., it does
not
incorporate those non-working time changes. For example, I have Date1 as
starting five days later than Start Date. However, it counts weekends and
holidays as part of the five days.

How do I calculate a date in Date1, Date2, etc that excludes non-working
days?

 

[Gérard Ducouret]

If you want to add several days to a date, use ProjDateAdd
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

No, actually I want to show several dates on one task. The start date,
Date1
(which typically occurs 5 business days later), Date 2 (which occurs 3
business days after Date1), etc. What formula would I use to calculate
the
new date which does not count holidays or weekends as part of the "5
business
days later"?

Greg,

You want to calculate the duration between Date1 and Date2, in working
days?
Use the ProjDateDiff function:
ProjDateDiff (date1,date2, "calendar")
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

I have marked company holidays as non-working time on the calendar using
Change Working Time. When I use a fomula in Date1, Date2, etc., it
does
not
incorporate those non-working time changes. For example, I have Date1
as
starting five days later than Start Date. However, it counts weekends
and
holidays as part of the five days.

How do I calculate a date in Date1, Date2, etc that excludes
non-working
days?

 

[Greg]

Thanks. That worked.

If you want to add several days to a date, use ProjDateAdd
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

No, actually I want to show several dates on one task. The start date,
Date1
(which typically occurs 5 business days later), Date 2 (which occurs 3
business days after Date1), etc. What formula would I use to calculate
the
new date which does not count holidays or weekends as part of the "5
business
days later"?

Greg,

You want to calculate the duration between Date1 and Date2, in working
days?
Use the ProjDateDiff function:
ProjDateDiff (date1,date2, "calendar")
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1


"Greg" <[email protected]> a écrit dans le message de (e-mail address removed)...
I have marked company holidays as non-working time on the calendar using
Change Working Time. When I use a fomula in Date1, Date2, etc., it
does
not
incorporate those non-working time changes. For example, I have Date1
as
starting five days later than Start Date. However, it counts weekends
and
holidays as part of the five days.

How do I calculate a date in Date1, Date2, etc that excludes
non-working
days?

 

[Gérard Ducouret]

You are welcome, Greg!
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

Thanks. That worked.

If you want to add several days to a date, use ProjDateAdd
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1

No, actually I want to show several dates on one task. The start date,
Date1
(which typically occurs 5 business days later), Date 2 (which occurs 3
business days after Date1), etc. What formula would I use to calculate
the
new date which does not count holidays or weekends as part of the "5
business
days later"?

:

Greg,

You want to calculate the duration between Date1 and Date2, in working
days?
Use the ProjDateDiff function:
ProjDateDiff (date1,date2, "calendar")
--
Gérard Ducouret

[Project MVP]
www.pragmasoft.fr
Un livre sur Project Server 2007 pour le Chef de projet:
http://www.lmet.fr/advsearch.cgi?_EXPRESSION=ducouret&_DISTANCE=10&_PAGE=1


"Greg" <[email protected]> a écrit dans le message de
(e-mail address removed)...
I have marked company holidays as non-working time on the calendar
using
Change Working Time. When I use a fomula in Date1, Date2, etc., it
does
not
incorporate those non-working time changes. For example, I have
Date1
as
starting five days later than Start Date. However, it counts
weekends
and
holidays as part of the five days.

How do I calculate a date in Date1, Date2, etc that excludes
non-working
days?