Skip to main content
Topics#Data ManagementPergunta de Colin Samson
Colin Samson (Evolve) perguntou em #Data Management
6 de jul. de 2012, 13:38

Date formula fields

Ok, there are so many date formula to exclude weekends.....I am very confused now.

 

So here's what I want to do.

 

I have a date field called Date_assigned_to_opportunity_owner__c, which is updated with workflow everytime the owner is changed.

 

I need a second formula date field that will add 2 business days to the Date_assigned_to_opportunity_owner__c, that means to exclude Saturday and Sunday.

 

So if the Date_assigned_to_opportunity_owner__c is 06 July 2012 (Friday), the new formula date field should read 10 July 2012.

 

How can I achieve this? Please dont just give me another link, I have read several of these, and need a proposed solution.
4 respostas
  1. KC Shafer (2U)
    6 de jul. de 2012, 13:47
    CASE(

     

    MOD( DATEVALUE(CreatedDate) - DATE (2000 ,1, 1) ,7),

     

    0,TODAY() + 3,

     

    1,TODAY() + 2,

     

    2,TODAY() + 2,

     

    3,TODAY() + 2,

     

    4,TODAY() + 2,

     

    5,TODAY() + 2,

     

    6,TODAY() + 4,

     

    null)

    Is that what you're looking for?

     

    --KC
Escrever uma resposta...
0/9000