=IFS(B16:O16,EOMONTH),(AND(TODAY()-F27>365,TODAY()-F27<10*365),1,AND(TODAY()-F27>10*365),1.5,AND(TODAY()-F27>90),0.5,AND(TODAY()-F27<90),0)
The IFS function call ends immediately after EOMONTH.
I figure you mean something like IFS(SUMPRODUCT(--(DAY(B16:O16+1)=1)),.... That is, if a date in B16:O16 is the end of a month, then that date plus 1 day would be the first of the next month.
Just noticed problems with other parentheses as well as almost certainly excluding cases in which TODAY()-F27 equals 90, 365, etc. In any event, you should use LOOKUP rather than IFS.
Actually, you could even use MATCH
The "?" as 3rd argument to IF returns the text ? if no date in B16:O16 is at the end of a month. Unclear what you'd want in that case.
Bookmarks