Hi All,
I'm stuck. I need a field update formula to extract data from between two characters (in this case commas). 

For Example: 00442178,01,1625196411116,JOSE,OMAR,MEJIA,SANCHEZ,214,

I want to extract the value between the 3rd and 4th comma. The number of commas will be consistent but not the number of characters between them. 

I’ve been able to find the first comma using FIND(“,”, Field__c, 1), but I can’t figure out how to start at the third comma and return all values between it and the fourth comma. Help?

Serena

Hi 

Can any expert help me to create a formula to calculate the # of weeks in the current month ro create a formula field

Thanks in adv