[Solved] Day of Week?

halw · Post by **halw** » Fri May 30, 2008 10:34 pm

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.

Searched help subjects and could not find.

TIA

edit this topic's initial post · Post by **Villeroy** » Fri May 30, 2008 11:37 pm

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 "NNN"] yields the same value as in A1, but shows the month name only
You could also get the string value:
B1: =TEXT(A1;"NNN")
TEXT returns the formatted string representation of a number.

Edit: Sorry, I mixed month names with day names. replaced "MMMM" with "NNN"

halw · Post by **halw** » Sat May 31, 2008 12:50 am

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:
B1: =TEXT(A1;"MMMM")
TEXT returns the formatted string representation of a number.

Thank you. Was drawing a blank on this.

danuneken · Post by **danuneken** » Sun Dec 16, 2012 10:04 pm

WHY so complicated?

jrkrideau · Post by **jrkrideau** » Mon Dec 17, 2012 2:18 pm

danuneken wrote:WHY so complicated?

I don't know but at a guess it is because time is much more complicated to calculate than simple numbers. Three hundred and sixty-five days in a year except when there are 366; 24 hours in a day but don't forget daylight savings time versus standard time, oh and every so often we add a second or so to the time and so on.

Post by **acknak** » Mon Dec 17, 2012 5:56 pm

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. ...

With the date in A1, =TEXT(A1;"NNN")

andreuccio · Post by **andreuccio** » Sun May 30, 2021 5:32 am

Hi i was wondering if there was a function to return the value of the weekdays to just the first two letters (e.g. Monday as Mo, Tuesday as Tu) to cut down on space.

I get that the function as is is =TEXT([cell w/ date];"NNN")

can it be more terse?

Post by **robleyd** » Sun May 30, 2021 11:35 am

If you want just the first two characters, the formula will be longer:

Code: Select all

=LEFT(TEXT(A1;"NNN");2)

That will return e.g Mo, Tu etc.

If three characters is acceptable, just use NN in the cell format instead of NNN and you won't need a formula.

edit this topic's initial post · Post by **Villeroy** » Sun May 30, 2021 11:47 am

NNN specifies the long weekday name.
NN specifies the abreviation.
=TEXT(A1 ; "NN") does the job.

andreuccio · Post by **andreuccio** » Sun May 30, 2021 5:25 pm

Wow! I'm so happy there's such an easy solution. Thanks y'all!

[Solved] Day of Week?

[Solved] Day of Week?

Re: Day of Week?

Re: Day of Week?

Re: [Solved] Day of Week?

Re: [Solved] Day of Week?

Re: [Solved] Day of Week?

Re: [Solved] Day of Week?

Re: [Solved] Day of Week?

Re: [Solved] Day of Week?

Re: [Solved] Day of Week?