| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format dates & add ten years to date
I imported a report into excel, in the report the effective dates are
yearmonthday (20090815). I would like to change these to a normal date format. I also need to in a seperate column show the date with ten years added, also if as of this month the effective date is within ten years or outside ten years. Any help would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format without retyping dates | Excel Worksheet Functions | |||
| Changing dates to date format | Excel Discussion (Misc queries) | |||
| Text dates to date format | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
![Jason K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
