function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shannon Andreas 21Shannon Andreas 21 

Formula to calculate 10 Business Days from Created Date

Hello Friends!

How would I edit this formula to reflect a date of 10 days days after created date? It currently covers 48 hours or 2 business days.

CASE( MOD( DATEVALUE( CreatedDate ) - DATE( 1900, 1, 7 ), 7 ),
  0, CreatedDate + 1 + 2, /* Sun: CreatedDate + 1 wknd day + 2 days */
  4, CreatedDate + 2 + 2, /* Thurs: CreatedDate + 2 wknd days + 2 days */
  5, CreatedDate + 2 + 2, /* Fri: CreatedDate + 2 wknd days + 2 days */
  6, CreatedDate + 2 + 2, /* Sat: CreatedDate + 2 wknd days + 2 days */
  CreatedDate + 2 /* Default (Mon/Tue/Wed): CreatedDate + 2 days */
)

Thanks!!!
Best Answer chosen by Shannon Andreas 21
Shannon Andreas 21Shannon Andreas 21
Suggestion given

CreatedDate + 14 since 10 business days has 2 weekends (4 days). Genious.