| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter the formula to show the current day of the week ?
I want to show the current date ..ie =(today) but in a column next to it I
want to show the day of the week. What is the formula ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter the formula to show the current day of the week ?
=day(A1), or whatever your cell reference is, then Format Custom Type
dddd Regards, Ryan--- -- RyGuy "Simple, but I don't know" wrote: I want to show the current date ..ie =(today) but in a column next to it I want to show the day of the week. What is the formula ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter the formula to show the current day of the week ?
In B1: =TEXT(A1,"ddd")
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Simple, but I don't know" wrote: I want to show the current date ..ie =(today) but in a column next to it I want to show the day of the week. What is the formula ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter the formula to show the current day of the week ?
Instead of using a second cell, you could just use a custom format:
Format|cells|Number tab|custom category: mmmm dd, yyyy dddd or mm/dd/yyyy dddd or some variation. Simple, but I don't know wrote: I want to show the current date ..ie =(today) but in a column next to it I want to show the day of the week. What is the formula ? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter the formula to show the current day of the week ?
Have you tried that suggestion, Ryan? What day does that give for today?
Try again with =A1 instead of =DAY(A1) -- David Biddulph "ryguy7272" wrote in message ... =day(A1), or whatever your cell reference is, then Format Custom Type dddd Regards, Ryan--- -- RyGuy "Simple, but I don't know" wrote: I want to show the current date ..ie =(today) but in a column next to it I want to show the day of the week. What is the formula ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to determine number of current records by week | Excel Worksheet Functions | |||
| Finding current week and if any item has somthing due | Excel Worksheet Functions | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| How do I set a formula to show a difference in sets of data enter | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
Linear Mode
