Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Consecutive date calculation involving holidays

0 views
Skip to first unread message

BMoran

unread,
Nov 12, 2009, 4:39:01 PM11/12/09
to
I know that you can figure out a date using the WORKDAY function, but how do
you figure out a date for just consecutive days.

I basically want to add days to an initial date while keeping a list of
holidays in mind.
A B
1 11/01/09

I want column B to add 50 days to column A while keeping track of the
holiday list. This is the formula I use for the Workdays:
=WORKDAY(A1,50,$J$1376:$J$1390)

Thanks!

Ron Rosenfeld

unread,
Nov 12, 2009, 4:57:28 PM11/12/09
to
On Thu, 12 Nov 2009 13:39:01 -0800, BMoran <BMo...@discussions.microsoft.com>
wrote:

If you look at HELP for the WORKDAY function, you will see how to use the
optional HOLIDAYS argument.
--ron

0 new messages