ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Weekday in English when using foreign version of excel (https://www.excelbanter.com/excel-programming/340157-weekday-english-when-using-foreign-version-excel.html)

mo_in_france

Weekday in English when using foreign version of excel
 
Hi all

I'm using French Excel 2003.

Is there a built in function/ combination of functions which will
return the day of the week in English.

I'm currently using a custom function based upon WeekDay() and a select
statement to convert the integer to the required string.

Thanks in advance for your help.


Bob Phillips[_6_]

Weekday in English when using foreign version of excel
 
=CHOOSE(WEEKDAY(A17),"Sunday","Monday","Tuesday"," Wednesday","Thursday","Fri
day","Saturday")

--
HTH

Bob Phillips

"mo_in_france" wrote in message
oups.com...
Hi all

I'm using French Excel 2003.

Is there a built in function/ combination of functions which will
return the day of the week in English.

I'm currently using a custom function based upon WeekDay() and a select
statement to convert the integer to the required string.

Thanks in advance for your help.





All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com