| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use a right formula on a date-format
Hi everybody,
My problem is this. I have a lot of cells containing dates 06-06-2006 etc. They are in a date format. I want the next column to only return the year i.e. 2006 in the above exampel. I tried the right formula - but that only returns the corresponding number (corresponding to the date) - any ideas? Regards Heine |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
Threaded Mode
