| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pick up date, month and year from a date | Excel Discussion (Misc queries) | |||
| Pick up format from another cell | Excel Discussion (Misc queries) | |||
| Pick up date for Charts from the Spreadsheet | Charts and Charting in Excel | |||
| Pick value at intersection of location & date (MMM-YY) | Excel Worksheet Functions | |||
| pick date from calendar in excel | Excel Worksheet Functions | |||
Linear Mode
