+ Start a Discussion
imishraimishra 

Formula fields for date(Very Urgent)

Hi,
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.

Thanks,
Ipsita

ShashForceShashForce
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.

Thanks,
Shashank
Vamsi KrishnaVamsi Krishna
Ipsita,
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..
MagulanDuraipandianMagulanDuraipandian
http://www.infallibletechie.com/2014/05/how-add-n-days-to-date-field-using.html

check this

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

Regards,
Magulan
http://www.infallibletechie.com