Table of Contents 1. SUM of Digits when cell Contains all Numbers 2. SUM of Digits when cell Contains Numbers and non Numbers both 3. A List is Unique or Not (Whether it has duplicates) 4. Count No. of Unique Values 5. Count No. of Unique Values Conditionally 6. Generate Sequential Weekday names like Sun, Mon, Tue, .....,Sat 7. Generate Sequential Month names like Jan, Feb, Mar....Dec 8. Find Last Day of the Month 9. Number of Days in a Month 10. Find First Day of the Month 11. Add Month to or Subtract Month from a Given Date 12. Add Year to or Subtract Year from a Given Date 13. Convert a Number to a Month Name 14. Convert a Month Name to Number 15. Convert a Number to Weekday Name 16. Convert a Weekday Name to Number 17. Financial Year Formula (e.g. 2015-16 or FY16) 18. Converting Date to a Calendar Quarter 19. Converting Date to a Indian Financial Year Quarter Source: Vijay A. Verma Kasra Jadid Haghighi, LinkedIn