|Edit: Sorry, I mixed month names with day names. replaced "MMMM" with "NNN"|
Villeroy wrote:See help on WEEKDAY. If you need the string for display purpose you may combine WEEKDAY with CHOOSE. You could also apply another number format:
A1: some date
B1: =A1 [plus number format "MMMM"] yields the same value as in A1, but shows the month name only
You could also get the string value:
TEXT returns the formatted string representation of a number.
danuneken wrote:WHY so complicated?
halw wrote:Looking for a function/formula that will take a date in a cell and convert it to the corresponding week day e.g. Monday, Tuesday, etc., in another cell. ...
Users browsing this forum: ken johnson and 48 guests