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
deepak.sharmadeepak.sharma 

Date formula calculation - Need urgent help.

Hi,

I need some help on a creating below date formula. If anyone can create for below condition that would be great help !

Date_formula_ field__c = TODAY() + Custom_field__c +1+(7-(WEEKDAY((TODAY()+Custom_field__c),12)))

Thanks,
Deepak
B TulasiB Tulasi
Hi Deepak,

What is your requirement. just ping me. 
deepak.sharmadeepak.sharma
Hi Tulasi,

I have mentioned my requirements above that I need to populate a date formula field which will be based on following calculation;

Date_formula_ field__c = TODAY() + Custom_Number_field__c +1+(7-(WEEKDAY((TODAY()+Custom_Number_field__c),12)))

If you know if above can achieved using formula then it would be really helpful.

Thanks,
Deepak
Manuel Jiménez GonzálezManuel Jiménez González
Can you explain what you try with this: "WEEKDAY((TODAY() + Custom_Number_field__c),12)   )"?