| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formula to return two digit year
I'm trying to perfect a formula that produces a two digit year from another
cell that contains a full date, for example: Y12 contains the following formatted as a date: 07-10-2008 In Y13 my formula is: =TEXT(YEAR(Y12),"##") No matter what I try I get: 2008 as a result rather than the intended: 08 I'm sure it is obvious, but can someone please assist. Thanks much in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Month & Year of Date Value | Excel Discussion (Misc queries) | |||
| Addendum to 2 digit year to 4 digit year | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Year-to-date return | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
