Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function to write Weekday - Monday, Tuesday etc
What is the function to write Weekday only (MOnday, Tuesday etc) from the
given date. For example, when I write date as 26 September 2005, the function should return the value of Monday. |
#2
|
|||
|
|||
Hello
Set a formula refering to the date and simply format cell as dddd HTH Cordially Pascal "Shrikant" a écrit dans le message de news: ... What is the function to write Weekday only (MOnday, Tuesday etc) from the given date. For example, when I write date as 26 September 2005, the function should return the value of Monday. |
#3
|
|||
|
|||
Hi
You don't need a function. Format CellsNumberCustom and set it to ddd If you did want to do it by function, then =TEXT(A1,"ddd") Regards Roger Govier Shrikant wrote: What is the function to write Weekday only (MOnday, Tuesday etc) from the given date. For example, when I write date as 26 September 2005, the function should return the value of Monday. |
#4
|
|||
|
|||
Apologies, 1 "d" too few.
format as "dddd" or TEXTA(A1,"dddd") Regards Roger Govier Roger Govier wrote: Hi You don't need a function. Format CellsNumberCustom and set it to ddd If you did want to do it by function, then =TEXT(A1,"ddd") Regards Roger Govier Shrikant wrote: What is the function to write Weekday only (MOnday, Tuesday etc) from the given date. For example, when I write date as 26 September 2005, the function should return the value of Monday. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weekday function | New Users to Excel | |||
Formula to list unique values | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions |