EOMONTH formula method not working in SharePoint calculated column

Question

_{Thursday, July 14, 2011 1:12 PM}

Hello,

I have tried using =EOMONTH([StartDate],0) in a SharePoint 2010 calculated column.

But its not taking it up.

Please help!!

Thanks

Ghouse

All replies (3)

_{Thursday, July 14, 2011 1:31 PM}

Hi

Here is the list of all the formulas for Date and Time.

http://office.microsoft.com/en-us/sharepoint-foundation-help/CH010372696.aspx

I dont think EOMONTH is available as a function.

To calculate what you need you have to use custom formula.

Here are some examples

http://abstractspaces.wordpress.com/2009/05/02/common-date-time-formulas-for-sharepoint-calculated-fields/

Cheers

Amit

_{Thursday, July 14, 2011 3:33 PM}

Hi Amit,

Thanks for your reply,

My requirement is to get last date of the month. In excel we use EOMONTH to get the same, but in sharepoint its not working.

Please suggest any formulae which gives last date of selected month (ex: 7/22/2011)

for example: to calculae last date of July month of 2011 is 31 days.

Thanks

Ghouse

_{Tuesday, July 9, 2013 6:31 PM}

I know this thread is two years old, but I happened to run into the same problem and thought this might help. The formula takes any date field and then goes to the 1st of the next month and then subtracts one day. This should always give the last day of the date field's month.

=DATE(YEAR(Modified),MONTH(Modified)+1,1)-1

UPDATE: I just saw that a form of this formula was first posted on October 1, 2012 by Athalis in the abstractspaces.wordpress.com link above.