Alternative to EOMONTH formula

[BigDelGooner]

As part of an ongoing issue that I won't bore you with I need to find an alternative to the EOMONTH formula that does not use any analysis toolpak references...any ideas guys?

 

[MrKowz]

Did you try ZVI's suggestion in your other post? It is a function you can use as a direct alternative to EOMONTH.

http://www.mrexcel.com/forum/showpost.php?p=2642345&postcount=9

 

[jasonb75]

If you want to do it purely with standard functions

=DATE(YEAR(A2),MONTH(A2)+x+1,0)

where x is the value previously used for the months parameter in EOMONTH

 

[BigDelGooner]

Thanks MrKowz, I was being incredibly dense! I was using the function in VBA anyway so totally forgot it can be used in worksheets. It's been a long week ha ha!

Thanks for your post too Jason.

Have a good weekend all.