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.

  • 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 – Oleksandr Berehovskyi Jun 7 '17 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 Jun 7 '17 at 7:40
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
  • 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 Jun 12 '17 at 4:28
  • @Cheryl yes, I've answered on it here – Oleksandr Berehovskyi Jun 12 '17 at 7:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.