Pick only date from DD/MM/YY format
 

Sir,

I have a data in which Column A contains date B contains programmes. I am
trying to get in column C that if date starts with 1 a particular programme
from B and if start with 15 some other programme. when i put the formulah
=left(A1,2) it brings 39 as answer. Is there any idea that how I can bring
the first two digits from the date column with out considering the month &
year.

thanks

Pick only date from DD/MM/YY format
 

Hi,

I'm not sure what you are trying to do but to extract the day portion of a
date try this with a date in A1

=DAY(A1)

If you need more help post you data layout.

Mike



"shaji" wrote:

Sir,

I have a data in which Column A contains date B contains programmes. I am
trying to get in column C that if date starts with 1 a particular programme
from B and if start with 15 some other programme. when i put the formulah
=left(A1,2) it brings 39 as answer. Is there any idea that how I can bring
the first two digits from the date column with out considering the month &
year.

thanks

Pick only date from DD/MM/YY format
 

=DAY(A1)


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 00:28:00 -0800, shaji
wrote:

Sir,

I have a data in which Column A contains date B contains programmes. I am
trying to get in column C that if date starts with 1 a particular programme
from B and if start with 15 some other programme. when i put the formulah
=left(A1,2) it brings 39 as answer. Is there any idea that how I can bring
the first two digits from the date column with out considering the month &
year.

thanks