| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching month and year column.
I need to use something like the below formula to match cell content from the date column of one tab (B30 = 8-Dec-06), to the date column of another tab (Dec-06). Notice one contains the day, the other only contains month-year. Obviously the below does not work. Is there something that will? TIA, Earl =LOOKUP(month(B30),month('Satchmo Storage'!$B$6:S$6),'Satchmo Storage'!$B$16:S$16) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding from one year to the next | Excel Discussion (Misc queries) | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| holiday dates | Excel Worksheet Functions | |||
| Matching the month and year portion of a date only | Excel Discussion (Misc queries) | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
Threaded Mode
