Hi.
I have a problem with the workday function. I have used it so that the formula adds 10 workings days onto the date in the previous cell.
The formula I have used is =WORKDAY(I17,10)

the formula works fine when I have it on my spreadsheet. But when I have transferred it to other computers most of them don't work. The result just comes up with Name?

why is it that the workday function doesn't work with some of the other computers. I thought it was because I was using the 2007 version of excel but all of the other computers have 2003 and some work while others don't.
Is there an update I have to install to get this function? If so where do it get it from?

Thanks

Quote:

---

Originally Posted by AJC_50

Hi.
I have a problem with the workday function. i have used it so that the formula adds 10 workings days onto the date in the previous cell.
The formula i have used is =WORKDAY(I17,10)

the formula works fine when i have it on my spreadsheet. But when i have transferred it to other computers most of them dont work. The result just comes up with Name??

why is it that the workday function doesnt work with some of the other computers. I thought it was because i was using the 2007 version of excel but all of the other computers have 2003 and some work while others dont.
Is there an update i have to install to get this function? If so where do it get it from?

Thanks

---

I have had this problem before. It could be one of these two things (could be other things, but these are the only things that worked for me personally).

1. Highlight the column with the formula in it. Go to Tools, text to column, and keep clicking next until you come to up click Finish. This helps me a lot.

OR

2. Highlight the column, Go to Tools/AddIns/Analysis Toolpak

I used this when using a similar function to yours. (Mine was =Networkdays(K2,M2)...

I hope this may be useful.