Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to split the cell which has the date formula (with day)
Hi,
i want to know if i have a cell with the date format, in which they show the day, & month, like: Monday, December 12, 2005 its a formatted cell, now if i want to pull the day in a diff. cell, what is formula for that pls. give me some solution for that Regards Gautam |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to split the cell which has the date formula (with day)
If the cell has the date, just link directly to the cell and format as
"dddd": A1: Monday, December 12, 2005 B1: =A1 Format B1 with Format/Cells/Number/Custom "dddd" In article , Gautam wrote: Hi, i want to know if i have a cell with the date format, in which they show the day, & month, like: Monday, December 12, 2005 its a formatted cell, now if i want to pull the day in a diff. cell, what is formula for that pls. give me some solution for that Regards Gautam |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to split the cell which has the date formula (with day)
"Gautam" wrote in message
... Hi, i want to know if i have a cell with the date format, in which they show the day, & month, like: Monday, December 12, 2005 its a formatted cell, now if i want to pull the day in a diff. cell, what is formula for that pls. give me some solution for that. Something like this any good? A1 =NOW() B1 =YEAR(A1) C1 =MONTH(A1) D1 =DAY(A1) E1 =HOUR(A1) F1 =MINUTE(A1) G1 =SECOND(A1) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to split the cell which has the date formula (with day)
You have different options depending on what you need.
=TEXT(A1,"dddd") will return Monday as a text string =A1 formatted as dddd will show as Monday, but the cell value will be equal to the date =DAY(A1) will return 12 (the twelth day in the month) =WEEKDAY(A1) will return 2 (the second day in a week; Sunday=1) Hope this helps. "Gautam" wrote: Hi, i want to know if i have a cell with the date format, in which they show the day, & month, like: Monday, December 12, 2005 its a formatted cell, now if i want to pull the day in a diff. cell, what is formula for that pls. give me some solution for that Regards Gautam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Conditional Formatting for dates | Excel Worksheet Functions |