On Wed, 12 Jan 2005 20:15:37 -0500, Ron Rosenfeld
wrote:

On Wed, 12 Jan 2005 04:25:03 -0800, "Aviator"
wrote:

What I have currently:
1 2 3 4
Col. D Col. E Col. F Col. G
12/23 12/27 12/28 12/29


This is the way I want it to look like.

Wanting to Skip Weekends & Holidays:
1 2 3 4
Col. D Col. E Col. F Col. G
12/23 1/3 1/4 1/5

Formula:
1 Input date scheduled to start: 12/23
2 ?
3 ?
4 ?

Note: AZ2:AZ25 are the listed holidays


Please Help! Thank you,

If I understand you correctly, you wish to generate a list of successive dates
which excludes Fridays, Saturdays, Sundays and holidays.

If you have the Analysis Tool Pak installed, you can use a slight modification
of the Workday function:

=workday(D40+(WEEKDAY(D40)=5),1,Holidays)

where Holidays is the range where you have stored a list of holidays.

You can, of course, "wrap" this in your IF statement:

=IF(D40="","",workday(D40+(WEEKDAY(D4)=5),1,Holid ays))


--ron

TYPO Alert: with the IF, should read:

=IF(D40="","",workday(D40+(WEEKDAY(D40)=5),1,Holid ays))


--ron