| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Date
Realize date stored in cell not as mm/dd/yy format, but how can i get any of
the three from the date Ie; concatenate month(name or number) to a phrase?? -- LDStrayer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Date
Hi,
Is this what you mean =TEXT(MONTH(A1),"MMMM") Mike " wrote: Realize date stored in cell not as mm/dd/yy format, but how can i get any of the three from the date Ie; concatenate month(name or number) to a phrase?? -- LDStrayer |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Date
=year(a1) =month(a1) =day(a1) You can wrap that into a TEXT formula and format the result, too. =TEXT(DAY(A1),"DDDD") results in "Sunday" -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46960 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Date
You'd need to use Weekday() instead of Day() as in =TEXT(WEEKDAY(A1),"DDDD")
=TEXT(DAY(A1),"DDDD") results in "Sunday" -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46960 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Date
Why not just =TEXT(A1,"DDDD") instead of =TEXT(WEEKDAY(A1),"DDDD") ?
-- David Biddulph "AnotherNewGuy" wrote in message ... You'd need to use Weekday() instead of Day() as in =TEXT(WEEKDAY(A1),"DDDD") =TEXT(DAY(A1),"DDDD") results in "Sunday" -- JBeaucaire |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Date
'cause it didn't occur to me? ;o)
I was just pointing out that the DAY() function won't give the desired results. "David Biddulph" wrote: Why not just =TEXT(A1,"DDDD") instead of =TEXT(WEEKDAY(A1),"DDDD") ? -- David Biddulph "AnotherNewGuy" wrote in message ... You'd need to use Weekday() instead of Day() as in =TEXT(WEEKDAY(A1),"DDDD") =TEXT(DAY(A1),"DDDD") results in "Sunday" -- JBeaucaire |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| How to link an Excel file due date to Outlook calendar date? | New Users to Excel | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Linear Mode
