| 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. |
| 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) | |||
Threaded Mode
