| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date with links
My ss contains links to another spreadsheet. In col A are dates. I need to
add only those pieces of information that are valid dates and not include the links, but I'm having a bit of difficulty. Here is the formula I used, but I get #value error. =SUMPRODUCT(--(MONTH(Burlington!$A$2:$A$201)=10),--(YEAR(Burlington!$A$2:$A$ 201)=2004),--ISNUMBER(--(MONTH(Burlington!$A$2:$A$201)))) Maybe is not possible? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Threaded Mode
