How do I get the EOM (end of month) if my start date is 10/07/2016 ? I'm new and having some trouble with this. Thanks.
You should be able to use this formula.
=IF(MONTH(Date4) < 12, DATE(YEAR(Date4), MONTH(Date4) + 1, 1) - 1, DATE(YEAR(Date4), 12, 31))
That got me going. Thank you Matt.
