Dates forward

J

Jessica

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
 
P

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

Jessica said:
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
Click to expand...
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
Click to expand...
day function but that only give a day of the week representation such as
MONDAY or the reverse of what I am looking for.
 
Top