You need to sign in to do that
Don't have an account?
imishra
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
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
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
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 :-)
Regards,
Magulan
http://www.infallibletechie.com