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

Formula fields for date(Very Urgent)

I have a date field called Project start date:
I have formula fields to calculate the consecutive last date from the project start date.
For e.g. 
Project start date= 01/06/2014
Date1(Formula) = 30/06/2014
Date2(Formula) = 31/07/2014
If it exceeds to next year that should also be considered. For e.g.
Project start date= 15/12/2014
Date1(Formula) = 31/01/2015
Date2(Formula) = 28/02/2015

I need the formula for date1 and date2.

Please help me to get this, its very urgent.


Hi Ipsita,

Can you explain more in detail how date 1 and date 2 are calculated? It does not look very straight forward from the 2 examples you provided.

Vamsi KrishnaVamsi Krishna
can you give the exact requirement on the consecutive last dates ? is it always end of the month and end of next month based on project start date ?
in ur first example date1 is ending on the same month as project start date
but in ur second example its ending in the next month of the project start date..

check this

If this solves your problem, kindly mark it as the best answer.
Hit Like, if it saved your work :-)