| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the year from a given date
I would like to know the formula by which we can find out the year from the
given dates Eg; Date of Joining coloum has 10/01/97, 05/06/2001 so from this i should get the year as 1997 and 2001... Kindly suggest some formula to help me out for the desired output |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last Saturday of the Year | Excel Discussion (Misc queries) | |||
| Use year and weeknr to find date?? | Excel Discussion (Misc queries) | |||
| Find the first Sunday for a given year? | Excel Worksheet Functions | |||
| 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
