|
|
|
|
#2
03-01-2015, 01:16 AM
|
||||
|
||||
Hi
Is 19780225 a text string, a number or a format custom date? Perhaps post a small sample sheet?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#4
03-01-2015, 01:31 AM
|
||||
|
||||
|
First select the dates - Data Ribbon - Text to columns - Delimited-Next -Next
Under Column data format set date to YMD - Click finish (you now have real dates) Apply formula as attached
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Tags |
| age, convert |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Convert all equations to "Normal Text"
|
b0x4it | Word VBA | 16 | 02-14-2023 03:52 AM |
| Can you review status in Project from a previous time prior to "Today" | StevieMar | Project | 3 | 04-30-2014 09:42 AM |
|
Convert "Figure", "Figure", "Figure" to "Figure1", "Figure2", etc.
|
altjx | Word | 4 | 06-04-2013 05:29 AM |
|
How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
| Outlook Today's "Inbox" and Showing New Mail for E | my02wg | Outlook | 0 | 03-19-2006 06:36 AM |
Windows 8 
Office 2010 64bit
Hybrid Mode