Only want to Add Bussiness days

[niladri20052006]

Hi All,

I have one day that is 23-Nov-11. I want see the date 90 days after but there will no Saturday and Sunday.

i am doing =23-Nov-11+90 but i do not want that. I want the date 90 days after but there will no Saturday or Sunday

How do I do that?

 

[Marcelo Branco]

=WORKDAY(A1,90)

A1=23-Nov-11

 

[Dryver14]

theres probably a clever formula but the end result is you want start date +126

(90/5)*7

 

[Dryver14]

workday function is more accurate i think

 

[Biz]

Workday is much better method to solve this issue.

Biz