+ 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.