function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Date Formula Needed



I am trying to find a formula/function in Salesforce that is the equivalent to the EOMONTH function in excel.  The excel function is as follows:


Scenario 1 =EOMONTH(A1,0)  => this gives me the end date of the month that is in cell "A1"


Scenario 2 =EOMONTH(A1,1)  = > this give me the end date of 1 month after the month  that is in cell "A1"


So if A1 is Jan 15,2009 the function would give me Jan 31, 2009 in scenario 1 and Feb 28, 2009 in scenario 2.


Does anyone know how this can be accomplished in Salesforce?

Best Answer chosen by Admin (Salesforce Developers) 
see my reply on

All Answers

Richie DRichie D

This has already been solved - see posting on VisualForce discussion board by same poster.


see my reply on
This was selected as the best answer