| 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 |
| 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 | |||
Threaded Mode
