| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date formatting
currently i have a date such as this in a the field; 08/13/2009, i want to
create another column and show only the year. how can this be done. assistance is appreciated. working on this report now and due soon. help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date formatting
SMASE, Inc.;452269 Wrote: currently i have a date such as this in a the field; 08/13/2009, i want to create another column and show only the year. how can this be done. assistance is appreciated. working on this report now and due soon. help. say your date is in cell K17, then in any other cell: =YEAR(K17) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125191 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date formatting
=YEAR(A1) works to get the year VALUE in the other cell
=A1 in the other cell and give the custom format of yyyy will leave the date in the second cell and DISPLAY the year best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "SMASE, Inc." wrote in message ... currently i have a date such as this in a the field; 08/13/2009, i want to create another column and show only the year. how can this be done. assistance is appreciated. working on this report now and due soon. help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date formatting
thank you for your knowledge and sharing of it. your response is greatly
appreciated. oh, by the way it worked ! "p45cal" wrote: SMASE, Inc.;452269 Wrote: currently i have a date such as this in a the field; 08/13/2009, i want to create another column and show only the year. how can this be done. assistance is appreciated. working on this report now and due soon. help. say your date is in cell K17, then in any other cell: =YEAR(K17) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125191 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| formatting of date | Excel Discussion (Misc queries) | |||
| Date formatting | Excel Discussion (Misc queries) | |||
| Date Formatting | Excel Discussion (Misc queries) | |||
| date formatting? | Excel Discussion (Misc queries) | |||
Linear Mode
