Forum Discussion
Excel Help
=IF(EOMONTH($A18,0)=EOMONTH(AU$1,0),EOMONTH($A18,0)-$A18+1,IF(EOMONTH($O18,0)=EOMONTH(AU$1,0),$O18-EOMONTH($O18,-1),IF(AND(AU$1>$A18,AU$1<$O18),EOMONTH(AU$1,0)-EOMONTH(AU$1,-1),0))) Good afternoo...
What are you trying to accomplish? It's hard to visualize from a formula without any context.