Good morning,
I'm using the below formula to display the oldest date in a range (to the end of the month) if there is a % value in a designated cell range.
=EOMONTH(MAXIFS('FA Afford'!I22:I33,'FA Afford'!E22:E33,">0"),0)
In an older version of the document I'm using (where the cell ranges for both the date and % to be checked are keyed manually) the formula works perfectly.
In the new version of the document, the cells ranges (I22:I33 and E22:E33) are populated in a different work sheet and then pulled through to the ranges on previous worksheet.
The data being fed through is no different on the face of it it's pulled through rather than being manually keyed.
If, on the new version (where I'm having the issue) I manually key over the date in I22 - the date formula works so it must be an issue with the way the date in I22 is pulled through but I can fathom what the problem is.
Any suggestions ?
I'm using the below formula to display the oldest date in a range (to the end of the month) if there is a % value in a designated cell range.
=EOMONTH(MAXIFS('FA Afford'!I22:I33,'FA Afford'!E22:E33,">0"),0)
In an older version of the document I'm using (where the cell ranges for both the date and % to be checked are keyed manually) the formula works perfectly.
In the new version of the document, the cells ranges (I22:I33 and E22:E33) are populated in a different work sheet and then pulled through to the ranges on previous worksheet.
The data being fed through is no different on the face of it it's pulled through rather than being manually keyed.
If, on the new version (where I'm having the issue) I manually key over the date in I22 - the date formula works so it must be an issue with the way the date in I22 is pulled through but I can fathom what the problem is.
Any suggestions ?
