Dates

[Red Balloon]

XP, 2007

I am a real newbie here. I want to be able to enter a date in column G and
have Excel calculate 4 business days earlier--not including weekends and
holidays--and place that date in column E.

If a formula is the answer, where do I put it? Do I place it in all cells in
that column?

Thanks for all of the great help.
Red Balloon

 

[Sean Timmons]

Don't think you need to use Add Ins for 2007..

You'll need to enter the holidays somewhere in yoru workbook. For this
example, assume they are in cells H2:H20

Assuming your dates start in row 2:

=WORKDAY(G2,-4,H2:H20)

goes in E2

Copy this cell and paste down the column to your last row of data.