G Guest Apr 11, 2006 #1 How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday. say for eg. a no. 3 should be formatted as Tuesday
How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday. say for eg. a no. 3 should be formatted as Tuesday
J John Vinson Apr 12, 2006 #3 How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday. say for eg. a no. 3 should be formatted as Tuesday Click to expand... Use the Choose() builtin function: DayName: Choose([DayNumber], "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday") John W. Vinson[MVP]
How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday. say for eg. a no. 3 should be formatted as Tuesday Click to expand... Use the Choose() builtin function: DayName: Choose([DayNumber], "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday") John W. Vinson[MVP]
