Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem Using Excel datenumber as Text reference
Hi, struggling here with Excels datenumber...
I have as source the following table: 2006 2007 Jan 10 12 Feb 8 9 Mar 9 11 etc... As a destination I have a report stating the following: Jan-07 12 Jan-06 10 Whereby my report uses the Microsoftdatenumber as a reference throughout, where Jan-07 is 39083 with the use of Format Cells Date ... This value will change according to the month we live in :-) Now the problem is: how can I use this datenumber to look up the according value in the crosstable? Normally I use INDEX() or VLOOKUP for this. However, if I try to get "Jan" as a lookupvalue, e.g. through (LEFT(); 3), this obviously does not return "Jan" but "390". Is there I way to do this, pref. without adding an extra, intermediate worksheet? Important backgroundinfo: My sourcefile is not made the way I would have it, but due to "userfriendlyness" (i.e. the user-skill-level) I cannot change that. Hope my question is at least understandable ^^ Thanx in advance for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts - Text Box Problem | Charts and Charting in Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Problem organizing text data into new excel page | Excel Worksheet Functions | |||
Slight problem automating Excel in a service | Setting up and Configuration of Excel |