Posted to microsoft.public.excel.worksheet.functions

Lloyd

external usenet poster

Posts: 41

Get Date of Birth from a ID Number

Please help
In Cell A2 6512160515084 in Cell A3 should be 1965/12/16, but if ID Number
starts with 0(0212160515084) should read 2002/12/16

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fomula for number of days on each month from a date range	[email protected]	Excel Discussion (Misc queries)	3	November 9th 06 03:08 AM
How to return a value between date ranges	Mary-Lou	Excel Worksheet Functions	7	May 26th 06 10:00 PM
date number separation	steven	Excel Discussion (Misc queries)	2	May 16th 06 05:42 AM
Where is DateDiff function in Excel 2002 ?	Nigel Welch	Excel Worksheet Functions	4	March 4th 05 03:18 PM
unwanted number to date conversion while pasting data from web	Jacek	Excel Worksheet Functions	1	February 24th 05 02:59 PM

All times are GMT +1. The time now is 02:59 AM.

About Us

"It's about Microsoft Excel"