Date manipulation

[Hayton]

Hi There,

I have a dte faormatted as follows:24/01/2005.

I need to extract the first cell the month and the second cell the year.

I have tried various options and can't get it right.

Any sugestions would be appreciated.

Hayton McGregor

 

[Hayton]

Don't worry guys I have worked it out.



Hayton McGregor

 

[SkipVought]

Hi,
[tt]
=Year(YourDate)
=Month(YourDate)
=Day(YourDate)
[/tt]
I'd stay away from any kind of string manipulation.

Skip,

_{[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment and urethric relief...
Pinot More!}

 

[fumei]

Good advice as usual Skip.

Gerry