 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Obtaining just the Year out of the date
Is it possible to obtain just the year in B1 out of a whole date in A1 ? I need to use the date in A1, in order to get a year, just THAT year in B1, in order to get a result in C1. It is complicated but the whole date in A1 I use it for 2 other purposes. and I need the year that happened to show in B1 in order to get a result in C1. Also is a long data, but having A1,B1 I'll just copy down the formulas. THANKS.  SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. Several ways to go, depending on exactly what you're intending to do with it in C1. Enter =A1 In B1, and custom format to yyyy Enter =Text(A1,"yyyy") In B1 Enter =Year(A1) In B1 SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Is it possible to obtain just the year in B1 out of a whole date in A1 ? > I need to use the date in A1, in order to get a year, just THAT year in B1, in [quoted text clipped - 4 lines] > Also is a long data, but having A1,B1 I'll just copy down the formulas. > THANKS. I'll be d... Yes, it works! THANKS Ragdyer and Gary's Student. Appreciate it. SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. > Several ways to go, depending on exactly what you're intending to do with it > in C1. [quoted text clipped - 22 lines] > > Also is a long data, but having A1,B1 I'll just copy down the formulas. > > THANKS. And we appreciate your feed-back. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I'll be d... Yes, it works! > THANKS Ragdyer and Gary's Student. Appreciate it. [quoted text clipped - 29 lines] > > > Also is a long data, but having A1,B1 I'll just copy down the formulas. > > > THANKS. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.