Dates forward

[Guest]

Hello
I need to caluclate 8 working days (mon-fri) from a date provided in a cell
For example
If I have the date 5/11/04 in one field I want another field to populate with 8 business days before 5/11/04 to equal 4/29/04 etc..
Is there a function or formula to do this? I have read about the working day function but that only give a day of the week representation such as MONDAY or the reverse of what I am looking for

Thanks
Jessica

 

[Peo Sjoblom]

=WORKDAY(Date,8,Holidays)

where Holidays can be a range of cells..

note that you need to have installed ATP

--

Regards,

Peo Sjoblom

Hello,
I need to caluclate 8 working days (mon-fri) from a date provided in a cell.
For example:
If I have the date 5/11/04 in one field I want another field to populate

with 8 business days before 5/11/04 to equal 4/29/04 etc...

Is there a function or formula to do this? I have read about the working

day function but that only give a day of the week representation such as
MONDAY or the reverse of what I am looking for.