You need to sign in to do that
Don't have an account?
Shannon 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!!!
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.