0

Example:

If Booking date is -> 7 June 2017, I want the formula to calculate the current month (June) + 3 months(90 days), and the formula should return 29th September 2017

Calculating as follows:

June + 90 days [31 days in July + 31 days in August + 28 days in September].

This formula is to be used in a process builder to set a expiry date.

2
  • I didn't get your example. If you 7 June 2017 +90 days = 5 September 2017, but not 29th September 2017 as you showed in example. Can you post one more example Commented Jun 7, 2017 at 7:33
  • So as today is 7th June, I want to retain entire June and counting of 90 days must start from July.
    – Cheryl
    Commented Jun 7, 2017 at 7:40

1 Answer 1

2

use the following formula to calculate desired date:

    IF(
        MONTH(BookingDate__c) == 12,
        DATE( 
            YEAR(BookingDate__c) +1, 
            1, 
            1
        ),
        DATE( 
            YEAR(BookingDate__c), 
            MONTH(BookingDate__c)+1, 
            1
        )
    )+90
2
  • Is there a way I could make these as full months? Example: Instead of exact 90 days from July, I would want it to be 3 full months from July. And the expiry date must be - 30th Sept 2017 (Last day of the month)
    – Cheryl
    Commented Jun 12, 2017 at 4:28
  • @Cheryl yes, I've answered on it here Commented Jun 12, 2017 at 7:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .