Hi all,
I'm having a problem with some date & time formulas.
At work, some people are using an english version of excel, while others are using a french version. I've never hade any trouble before with my formulas until now. I'm using the following formulas on an english version :
- workday;
- networkdays;
- weeknum
which translate correctly when I open the workbook in french to serie.jour.ouvre, nb.jours.ouvres and no.semaine respectively. The problem is when I save and open the workbook again on an english version, those formulas stay the same and won't translate, and give me a #name error.
I wonder if anybody as ever encoutered this before, and if so, how can I work around?
Thank you.
I'm having a problem with some date & time formulas.
At work, some people are using an english version of excel, while others are using a french version. I've never hade any trouble before with my formulas until now. I'm using the following formulas on an english version :
- workday;
- networkdays;
- weeknum
which translate correctly when I open the workbook in french to serie.jour.ouvre, nb.jours.ouvres and no.semaine respectively. The problem is when I save and open the workbook again on an english version, those formulas stay the same and won't translate, and give me a #name error.
I wonder if anybody as ever encoutered this before, and if so, how can I work around?
Thank you.
Last edited: