 ShowAll Questionssorted byDate Posted nksf

# Formula Field to Get Future Date

Hi Guys I need your help with this Formula field. It is very urgent.
We have Formula Field Billing Frequency and we have PurchaseDate Standard Date Field
I need to create a Formula Field to Calculate the Future Bill Date
Scenario:
If we have Billing_Frequency__c = Monthly and PurchaseDate = 8/1/15 and EndDate = 12/1/15
Suppose Today() Date is 9/23/15
then if Today() Date is > PurchaseDate and < EndDate then this Formula Field should show Future Bill Date as 10/1/15
so when Today() Date be 10/2/15 then this Formula Field should show Future Date as 11/1/15
If Today() Date is <= PurachaseDate then this Formula Field show just show PurchaseDate
In case Today()Date is < EndDate then this Field should be Blank.

If we have Billing_Frequency__c = Quarterly and PurchaseDate = 8/1/15 and EndDate = 12/1/16
Suppose Today() Date is 9/23/15
then if Today() Date is > PurchaseDate and < EndDate then this Formula Field should show Future Bill Date as 2/1/16
so when Today() Date be 2/2/16 then this Formula Field should show Future Date as 5/1/16
If Today() Date is <= PurachaseDate then this Formula Field show just show PurchaseDate
In case Today()Date is < EndDate then this Field should be Blank. Prolay
```IF( ISPICKVAL( Billing_Frequency__c ,'Monthly' ) &&  (PurchaseDate__c >  TODAY() &&  EndDate__c < TODAY() ),DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())),

IF( ISPICKVAL( Billing_Frequency__c ,'Quarterly' ) &&  (PurchaseDate__c >  TODAY() &&  EndDate__c < TODAY()),DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY())), NULL))```
Hope this helps!