Need formula to get EOMONTH

[ArcticAce]

How can I change this formula to get the EOMONTH?


=IF(AND([@[Discussion]]>=$AQ$3,[@[Discussion]]<=$AQ$4),$E4+45,[@[Discussion1]]-89)


If I use this formula I don't get the proper EOMONTH, so for FEB, I get 3/3/2018.

It works ok for JAN, but I need the proper EOMONTH for the entire column.

Thanks in advance for your assistance.

 

[jproffer]

I'm pretty sure there's an End of month function, which I assume you know since you used the right name (EOMONTH). Does that not work for some reason?

 

[Tetra201]

Maybe

=IF(AND([@Discussion]>=$AQ$3,[@Discussion]<=$AQ$4),$E4+45,EOMONTH([@Discussion1]-99,0))

 

[ArcticAce]

Tetra201, thank you and that worked perfectly. Now I have a new issue. Can I make this a multiple if function. My situation is that the discussions happen monthly, but don't start until the employee completes training. The cycle starts in October, and ends in November. There are special stipulations for any employee starting after 7/4/2018, so AQ3=7/4/2018 and AQ4=9/30/2018. The issue is any employee starting after the month of Oct will have a discussion due in December, so I am trying to get November to not show a date, if that makes since. I have AV3=11/1/2018 and AV4=7/3/2018, to use in the second IF, if that is part of what I need.

 

[ArcticAce]

Can anyone help with this issue?