Calculate working dates.

[amna77]

Hi, in cell A1, I have date like Oct 10. now in cell B1, I want to put a formula. Right now I have formula
=IF(ISERR(A1/A1)=TRUE,"",A1+10-IF(C5="Assy",10,))

this formula forward 10 days form cell A date. Like for example, If Cell A have March 10, then it gives me March 20, but if in cell c I have "Assy" then it does not add 10 days, it leaves the date like it is.

But now I want to add only 10 working days to that date. I want to ignore weekends.
Anybody know how I am going to modify my formula according to that?

Thanks

 

[Joe4]

Use the Workday function. Type "workday" in help and it will tell you how to use it. You will need at add the Analysis Toolpak Add-In, if you don't already have it, to use this function.

 

[amna77]

In a workday function help, it does not tell me, that how to add days to one date. they have start date and end date examples.

 

[Joe4]

Sure it does, that is exactly what it does. Read the description again.

For example, if you wanted to add 10 business days to today, it would be:

=workday(today(),10)
This message was edited by jmiskey on 2002-10-31 09:24

 

[amna77]

Thanks a lot, its working.
Thank you.