+ Start a Discussion
HaralambyHaralamby 

EOMONTH Function in Excel - Please help!!!

Hello,

 

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 the 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) 
Richie DRichie D

Hi,

 

You can do someting like:-

 

formula date field:-  "DATE(Year(Today()),Month(Today())+1,1) -1" for the last day in this month

 

 You'll have to handle to issue of month=12; add 1 to year, set month to be 1.

 

Date, Month and Year functions will be useful to you in this. 

 

R.