Pick only date from DD/MM/YY format

S

shaji

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change from mm/dd/yy to yy/mm> 3
Date Format Not Responding to MM/DD/YY 2
Entering date as MM/DD/YY no longer works, why? 1
visual basic user form date format dd/mm/yy not mm/dd/yy 1
Convert date to text without changing format dd/mm/yy 3
how do i split a cell that contains dd/mm/yy into a 3 separate cel 2
Sumproduct and weekday from mm/dd/yyyy format? 3
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3

Top