Dates

  • Thread starter Thread starter Red Balloon
  • Start date Start date
R

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
 
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.
 
Back
Top