UKMAN wrote:
the formula below allows me to state the number of days by month i.e. 10 days
from 23rd April means 8 in April and 2 in May.
I have 2 issues with it though.
{=IF($H$16:$H$30=A4,SUMPRODUCT(--ISNUMBER(MATCH(ROW(INDIRECT($B4&":"&$C4)),ROW(INDI RECT(DATE(YEAR(D$1),MONTH(D$1),0)+1&":"&D$1)),0))) ,)}
Issue 1:
H16:h30 is a list of names, A4 is the name of the student
Using the formula I can divide the dates over the months but for some
reason when I try to match a name (a4) against the list (h16:h30) I only ever
match the first name i.e. what is in h16??? other wise I get a "FALSE"
statement.
Issue 2: How can I amend the formula to only show the "working days" in the
return value i.e. 10 days from 23rd April means 6 in April and 4 in May.
many thanks
What is in B4, C4 and D1? And what does this have to do with the subject of
your post?