Extract Number From Different Format (Date Vs General)

[muhammad susanto]

hi guys...

how to extract this number which 2 condition (date format and general format)

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]data sample[/TD]
[TD]desired result[/TD]
[/TR]
[TR]
[TD]08/12/2005 (date format)[/TD]
[TD]2005[/TD]
[/TR]
[TR]
[TD]01/07/1992 (date format)[/TD]
[TD]1992[/TD]
[/TR]
[TR]
[TD]2001-10-380 (general format)[/TD]
[TD]2001[/TD]
[/TR]
[TR]
[TD]1986-7-451254 ((general format)[/TD]
[TD]1986[/TD]
[/TR]
</tbody>[/TABLE]

hope, someone could help me...

m.susanto

 

[bosco_yip]

hi guys, thank for all, it works

i have a new challenge for you to reverse order :

08/12/2005 (date format)----2005-12-08 (as text format)
01/07/1992 (date format)---1992-07-01 (as text format)
1986-7-45 (as text) ----1986-7-45 (as text- not change)
2001-10-380 (as text)---2001-10-380 (as text- not change)

Try,

Select range of cells in Column A >> Data >> Text to Columns >> Next >> Next >> Step 3 of 3; column data format, choose : "Text"; click Finish

Regards

 

[danster1984]

Hi Guys

well this is what i need and simply cant figure it out.

H1 = drop down list with the following choices ( Waiting Docs, In Progress, Approved, Invoiced)
AA1:AA4 = this is where I need the end result displayed

Require a formula that automaticly determines how long it took from In Progress status till it reached Approved in the number of days.

Your kind assistance is much appreciated

Sincere thanks

 

[xenou]

Hi Danster1984,
I suggest you ask your question by starting a new thread as this thread is about a different topic. Also you'll probably need to provide more information because what you've described here isn't enough to determine what the formula you need would be or what type of formula it would be.

Regards,
xenou (moderator).