Hello,
I'm looking for a date in a range of 1-31 of every month for the next 3 years. My range is in column H and I (H=01/mm/yyyy and I=31/mm/yyyy) in column J is written jan-15, feb-15...
In column D I have my dates (ex 15/05/2015) and in column C I want to have written only may-15.
Formula I use is next:
IF(ISERROR(INDEX($J$51:$J$90,MATCH(SUMPRODUCT(($H$51:$H$90<=D25)*($I$51:$I$90>=D25)*($H$51:$H$90)),$H$51:$H$9,0))),"",INDEX($J$51:$J$90,MATCH(SUMPRODUCT(($H$51:$H$90<=D25)*($I$51:$I$90>=D25)*($H$51:$H$90)),$H$51:$H$9,0)))
But it's working only if in D I have dates from 1st to 31st january or february 2015, for the other months and years no.
You can find attached my workbook, the IF formula is in sheet 'LOT' D25:D44
Bookmarks