| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Obtaining 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. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining just the Year out of the date
=YEAR(A1)
-- Gary''s Student - gsnu200788 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining just the Year out of the date
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 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Learning Excel" wrote in message ... 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. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining just the Year out of the date
I'll be d... Yes, it works!
THANKS Ragdyer and Gary's Student. Appreciate it. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Ragdyer" wrote: 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 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Learning Excel" wrote in message ... 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. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining just the Year out of the date
And we appreciate your feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Learning Excel" wrote in message ... I'll be d... Yes, it works! THANKS Ragdyer and Gary's Student. Appreciate it. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Ragdyer" wrote: 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 -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Learning Excel" wrote in message ... 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. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| generate report from date and obtaining all data in row | Excel Discussion (Misc queries) | |||
| Help w/formula to add 1 year to cell (date done) date due? | Excel Worksheet Functions | |||
| pick up date, month and year from a date | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Linear Mode
