You need to sign in to do that
Don't have an account?
Haralamby
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?
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.