function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
LarryHLarryH 

Expanded Date Caluclation for Invoice Credits

I'm trying to expand upon a formula I built which calculates the month in which a customer can expect to see a credit on an invoice.

 

Our process is that if a credit is submitted on the 25th or before in any given month, it will be reflected on the next invoice. If it is submitted after the 25th, it will be reflected on the invoice of the following month.

 

I would like to expand my current formula so that it displays the name of the month the credit will appear. My current formula is the following and uses a custom field called 'Submitted Date":

 

IF( DAY( Submitted_Date__c ) <= 25, "Next Invoice", "Following Months Invoice")

 

Any ideas as to how I can expand this so that the correct month value is displayed? I've been playing with CASE and MONTH and if I solve this, I will definitely post how I've done so. Thanks!

 

-Larry