You need to sign in to do that
Don't have an account?
![Shannon Andreas 21 Shannon Andreas 21](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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!!!
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!!!
CreatedDate + 14 since 10 business days has 2 weekends (4 days). Genious.